Help Table of Contents

Client Help

  1. User Types and Roles
  2. Pro User
    1. Pro Workflow Overview
    2. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
            1. Context Menu
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Quick Open
        3. App Tab Manager
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
          1. Dynamic Clipboard Tools
        3. Text Formatting
        4. Saving Content
          1. Assigning Content Access
        5. Print and Export
          1. Printing from Embedded Content
        6. Subscriptions
          1. Configure Subscriptions
        7. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
        8. Data Source Authentication
    3. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    4. Pro Apps
      1. Model
        1. Data Modeling Concepts
          1. Model Files vs Deployed Models
          2. External Models vs Pyramid Models
          3. Data Flows vs Semantic Models
        2. Smart Modeling
          1. New Smart Model
          2. Smart Modeling Heuristics
          3. Manage Smart Models
            1. Open And Edit Smart Models
            2. Save Smart Models
            3. Secure Smart Models
            4. Rerun Smart Models
        3. Model Lite
          1. New Lite Model
            1. Target
            2. Data
            3. Tables
            4. Columns
            5. Hierarchies
            6. Finish and Build
            7. Model Lite Heuristics
          2. Manage Lite Models
            1. Open Edit Lite Models
            2. Save Lite Models
            3. Rerun Lite Models
        4. Direct Model
          1. Servers
          2. Schema Display
          3. Relationships and Joins
          4. Managing Direct Models
            1. Save a Direct Model
            2. Open and Edit a Direct Model
            3. Process a Direct Model
            4. Rerun Direct Models
        5. Model Pro
          1. Model Pro Examples
          2. Master Flow
            1. Master Flow Interface
            2. General Nodes
              1. Data Flow
              2. SQL Script
              3. Data Model
              4. Set Variable
              5. Rest APIs
              6. Pyramid Event
              7. Command Line Support
              8. On Demand Schedules
              9. Wait
            3. Looping Steps
              1. For Loop
              2. For Each Loop
              3. While Loop
            4. Conditional
              1. Conditional Node
              2. Switch Statement
            5. Messaging
              1. Email
              2. SMS
            6. Master Flow Validation
          3. Data Flow
            1. Data Flow Interface
              1. Data Flow Ribbon
              2. Properties
              3. Node Selection
              4. Datasource Preview
                1. Column Statistics
              5. Variables
                1. Variables Panel
                2. SQL Variables Vs Static Variables
                3. Incremental Loading
                4. Inject Variables
              6. Workspace Layout
              7. Split Nodes
            2. Sources
              1. Data Sources and Targets
              2. Direct Query vs Ingested Data
              3. Use Existing Semantic Model
              4. File Sources
                1. Pyramid Reports
                2. Access
                3. Excel
                4. Google Sheets
                5. Provide a JSON File Source
                6. Multi Files
                7. SAS Data Set Source
                8. Text File Sources
                9. XML File Source
              5. Relational Sources
                1. Pyramid In Memory Database
                2. SAP HANA Datasource
              6. BigData Sources
                1. Adding Big Query as a Data Source
                2. MongoDb Datasource
              7. Cloud Sources
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. Facebook Data Source
                5. Google Analytics (GA4)
                6. Google Drive
                7. RSS
                8. SalesForce
                9. SharePoint
                10. SFTP (SSH) and FTP
                11. X (Twitter) Data Source
              8. Other Sources
                1. ODBC
                2. ODBC Direct
                3. OData Datasource
                4. Date Range Source
                5. Scripted Sources
                  1. Python Source
                  2. R Source
            3. Data Flow Targets
              1. Target Tables
              2. Pyramid IMDB
              3. File Targets
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. CSV
                5. Excel
                6. Google Drive
                7. Parquet
                8. SFTP (SSH) and FTP
                9. Folder Path Expression
              4. Relational Targets
                1. Custom Target Schema
                2. Execute a Script
              5. Big Data and Unstructured Targets
            4. Select
              1. Query
              2. Table
              3. Multi Tables
              4. Bottom N
              5. Top N
            5. Preparation
              1. Add Date/ Time
              2. Add Sequence
              3. Date Range
              4. Distinct
              5. Filter
              6. GeoCode
              7. Materialized Masking
              8. Modify Case
              9. Pivot
              10. Random Number
              11. Remove Duplicates
              12. Sort
              13. Summarize
              14. Time Intelligence
              15. Unpivot
            6. Gen-AI
              1. LLM Translate
              2. LLM Sentiment
              3. LLM General
            7. Column Operations
              1. Calculated Columns
                1. Custom Column PQL Editor
              2. Combined Columns
              3. Convert Columns
              4. JSON Extract
              5. Rename Columns
              6. Reorder Columns
              7. Split Columns
              8. Add Date Unit
              9. Date Difference
              10. Replace
              11. String Left
              12. String Right
              13. Substring
              14. Trim
              15. Aggregate FX
              16. Math FX
              17. Trig FX
            8. Joins
              1. Merge Join
              2. Union Join
            9. Machine Learning
              1. Machine Learning Functions
                1. Decision Tree
                2. Naïve Bayes
                3. Regression Trees
              2. Tensor Flow
              3. Machine Learning Nodes
              4. Machine Learning Examples
            10. Scripting
              1. Scripting Mechanics
                1. Scripting Inputs and Outputs
                  1. Data Frame Support
                2. Learn and Predict Scripts
                  1. Python Learn and Predict Examples
                3. Save Machine Learning Models
                4. Generate Your Script
                  1. Explain Script
                5. Marketplace
                  1. Marketplace Scripts
                    1. Sentiment Analysis Example
                    2. Basket Analysis Example
                6. Shared Scripts
                7. Virtual Scripting Environments
              2. Python Scripting
              3. R Scripting
            11. Validate Data Flow
            12. Model Transfer Cleanup
          4. Data Modeling
            1. Model Ribbons
              1. Configuration Ribbon
              2. Tables Ribbon
              3. Columns Ribbon
              4. Hierarchy Ribbon
            2. Configuration
              1. MS Tabular Models
              2. Auto Indexing
              3. Query Caching
            3. Tables Panel
              1. Relationships and Tables
              2. Relationship Table Editor
              3. Sync Settings
              4. Connector Types
              5. Context Menus and Properties
              6. Auto Table Update
              7. Automatic Column Handling
              8. Joins
                1. Heuristics
                2. Join Keys
                3. Bidirectional Joins
                4. Join Validation
              9. Columns
                1. Column Visibility
                2. Column Description
                3. Data Catalog
                4. Column Folders
                5. Column Categories
                6. Dynamic Data Masking
              10. Measures
                1. Measure Types
                  1. Cumulative Measure
                  2. Semi Additive Measures
                2. Measure Formats
                3. Measure Folders
                4. Measure Descriptions
                5. Multi-Measures
                6. Measure Editor
                7. Units and Currency
              11. Primary Keys and Indexing
              12. Special Tables and Columns
                1. Aggregate Tables
                2. Security Tables and Columns
                3. Distribution Tables and Columns
                4. Add Custom Query Table
            4. Columns
              1. Column Configuration
                1. Configure Custom Maps
              2. Multi-Measures Panel
              3. Column Sorting
              4. Virtual Column Calculations
                1. Calculated Columns Panels
                2. Calculated Columns Settings
                3. Calculated Column Walkthrough
            5. Hierarchy Panel
              1. Hierarchy Panel Mechanics
                1. Hierarchy Metadata
                2. Ragged Hierarchies
                3. Parent Child Hierarchies
                  1. Build Parent Child Hierarchies
                  2. Parent Child Hierarchy Examples
            6. Translations Panel
              1. Translations Attribute
          5. Model Processing
            1. Quick Discovery
            2. Schedule a Data Model
            3. Node Execution Status
            4. Progress Panel
          6. Security
            1. Security Settings
            2. Data Source Management
          7. Model Management
            1. Open and Edit a Model
            2. Save Models
            3. Printing and Documentation
      2. Discover
        1. Viewing Discover Content
        2. Natural Language Querying
          1. Accessing NLQ in Discover
          2. NLQ Chatbot
          3. Example: Build a Visual using the Chatbot
          4. Writing NLQ Questions
            1. NLQ: Advanced Intelligence
            2. NLQ: Visualizations
          5. Managing NLQ Discoveries
        3. Smart Discover
          1. Access Smart Discover
          2. Smart Discover Workspace
            1. Item Selection Bar
            2. Visualization Picker
              1. Smart Visualization Mechanics
            3. Design Panel
          3. Build Smart Discoveries
            1. Values
            2. Dimensions
              1. Custom Selections
              2. Sort and Filter Hierarchies
              3. Working with Dates
                1. Date-Time Calculations
                2. Date Parts
            3. Data Filters
            4. Visualizations
              1. Quick Styles
                1. Quick Styles
                2. Quick Styles for Grids
                3. Quick Styles for Cartesian Charts
                4. Quick Styles for Segment Charts
                5. Quick Styles for Plotted Charts
                6. Quick Styles for Maps
          4. Manage Smart Discoveries
            1. Save and Share
        4. Discover Lite
          1. Access Discover Lite
          2. Discover Lite Workspace
            1. Drop Zones
            2. Discover Lite Ribbon
              1. Axis Options
              2. Data Labels
              3. Data Points
              4. Grid Lines
            3. Model Metadata and Trees
          3. Build Visuals in Discover Lite
            1. Drop Zones
            2. Visualizations
              1. Quick Styles
            3. Dynamic Interactions
            4. Quick Calculations
            5. Context Calculations
          4. Manage Visuals in Discover Lite
          5. Conversations
        5. Discover Pro
          1. Access Discover Pro
            1. Pyramid Models
              1. Direct Model on a Database
              2. Direct Model with SQL
            2. Microsoft Models
            3. SAP Models
              1. SAP HANA Views
              2. SAP BW Models
          2. Discover Pro Workspace
            1. Discover Pro Ribbons
              1. Panel Layout
              2. New Report
            2. Panels
              1. Drop Zones Panel
              2. Data Model Trees
                1. Dimensions and Hierarchies
                  1. Hierarchy Types
                  2. Hierarchy Properties
                  3. Measure Group Filtering
                  4. Alternative Captions
                    1. SAP BW Technical Names
                2. Elements
                3. Measures
                  1. Measure Properties
                4. Refresh Metadata
                5. Languages
              3. Visualizations
              4. Content Panel
              5. Query Metadata Panel
              6. Performance Dialog
              7. Smart Insights
          3. Navigating and Querying Data
            1. Building Queries
              1. Using Data Model Metadata
                1. Using the Hierarchies Tree
                  1. Using Attribute Hierarchies
                  2. Using Regular Hierarchies
                  3. Using Drill Path Hierarchies
                  4. Using Parent-Child Hierarchies
                  5. Using Geospatial Hierarchies
                  6. Using Date-Time Hierarchies
                  7. Using Image URL Hierarchies
                  8. Using URL Hierarchies
                  9. Using Hidden Hierarchy Properties
                2. Using the Elements Tree
                  1. Elements Tree Context Menu
                  2. List Builder
                  3. Members Search
                3. Using the Measures Tree
              2. Drop Zones
                1. Values Drop Zone
                  1. Colorize Values
                  2. Shapify Values
                2. Column and Row Drop Zone
                3. Categories Drop Zone
                4. Trellis Drop Zones
                5. Color Drop Zone
                6. Shape Drop Zone
                7. Size Drop Zone
                8. Labels Drop Zone
                9. Tooltip Drop Zone
                10. Indicator and Status Drop Zones
                11. Motion Drop Zone
                12. Details Drop Zone
                13. Map Location / Shape Drop Zone
                14. Filters Drop Zone
                  1. Calendar Slicers
                    1. Calendar Pickers
                    2. Calendar Slicer Settings
                  2. Tree Slicer
                  3. Slicer Limits
                  4. Cascading Slicers
                    1. Manually Building Cascading Slicers
                  5. Slicer Settings
                  6. Slicer Styles
                  7. Slicer Formatting
                  8. Background Filters
                  9. Making Slice Selections
                  10. Bookmarks
                  11. Pre-Query Slicers
                    1. Manage Pre-Query Bookmarks
                15. More Drop Zone Options
                  1. Copy or Move
              3. Building Visualizations
                1. Raw Results
                2. Grids
                  1. Matrix Grid
                  2. Tabular Grid
                3. Cartesian Charts
                  1. Column Chart
                  2. Stacked Column Chart
                  3. Stacked 100 Column Chart
                  4. Marimekko Chart
                  5. Bar Chart
                  6. Stacked Bar Chart
                  7. Stacked 100 Bar Chart
                  8. Tornado Chart
                  9. Multi-Measure Charts
                  10. Combo Charts
                  11. Line Chart
                  12. Point Charts
                  13. Lollipop Charts
                  14. Area Chart
                  15. Stream Chart
                4. IBCS-Like Charts
                  1. IBCS-Like Area Chart
                  2. IBCS-Like Column Chart
                  3. IBCS-Like Line Chart
                  4. IBCS-Like Lollipop Chart
                5. Segment Charts
                  1. Pie Chart
                  2. Doughnut Chart
                  3. Pyramid Chart
                  4. Funnel Chart
                  5. Multi-Measure Segment Charts
                6. Radar Charts
                7. Plotted Charts
                  1. Scatter Chart
                  2. Bubble Chart
                  3. Scatter Line Chart
                8. Advanced Charts
                  1. Tree Map Chart
                  2. Hierarchical Tree Map Chart
                  3. Circle Packing Chart
                  4. Hierarchical Circle Packing Chart
                  5. Sankey Chart
                  6. Word Cloud
                  7. Sunburst Chart
                  8. Icicle Chart
                9. KPI Charts
                  1. Gauges
                  2. Bullet Chart
                10. Maps
                  1. Bubble Maps
                  2. Shape Maps
                    1. Custom Maps
                  3. Geo Heat Map
                  4. Map Quick Styles
                  5. Geo-Boundary
                11. Other Charts
                  1. Candlestick Chart
                  2. Box and Whisker Chart
                  3. Waterfall Chart
                  4. IBCS-Like Waterfall Chart
                12. Custom Visuals
                13. Conditional Formatting
                  1. Conditional Formatting Context Menu
                  2. Conditional Formatting via Drop Zones
                    1. Value Driven Colors
                    2. Conditional Color Examples
                    3. Text Indicator
                  3. Conditional Formatting Dialog
                  4. Conditional Formatting Logic
              4. Running Queries
                1. Query and Report Reset
            2. Changing and Manipulating Queries
              1. Query Interactions
                1. Drill-Up and Drill-Down
                2. Dice, Add, Swap, and Remove
                3. Expand and Collapse
                4. Element and Data Point Selection
                  1. Focus and Descendants
                5. Fill the Blanks
                6. Quick Sort
                  1. Set Element Order
                7. Quick Filter
                8. Pivot
                9. Quick Totals
                10. Explain
                  1. Explain explained
                  2. Explain the Difference
                11. Extended Query Interactions
                12. Interactive Selections
              2. Query Functions
                1. Show or Hide Empties
                2. Totals
                3. Sorting
                4. Value Filtering
                5. Eliminations
                6. N-of-N
                7. Hide Query Info
              3. Advanced Query Functions
                1. Forecasting
                  1. Basic Forecasting
                  2. Advanced Forecasting
                    1. Custom Forecast Scripts
                2. Regression Functions
                3. Statistics
                4. Pareto
                5. Clustering
                6. Outliers
                7. Fill Blanks
            3. Calculations in Discover
              1. Quick Calculations
                1. Group Calculations
                2. Quick Formulas
                3. Quick Lists
                  1. Quick Variable Lists
                4. Quick Parameters
                  1. Quick Static Parameters
                5. Quick KPIs
                6. Managing Quick Calculations
                  1. Saving and Sharing Calculations
                  2. Internal Parameters
              2. Context Calculations
                1. Difference Context Functions
                2. Cumulative Context Functions
                3. Statistical Context Functions
                4. Advanced Analytic Context Functions
                5. Managing Context Calculations
                6. Customizing Context Calculations
              3. Custom Columns
                1. Aggregations
                2. Categorization
                3. Date Parts
                4. String Functions
                5. AI Driven Columns
                6. Managing Custom Columns
              4. Other Calculation Tools
                1. Time Calculation Wizard
                  1. To Date
                  2. Last n Periods
                  3. Periods
                    1. Full Period
                    2. Period On Period
                    3. Parallel Day
                    4. Parallel Period
                2. Variable Lists
            4. Query Options
              1. Query Settings
              2. Choose Language
              3. Model Colors and Formats
          4. Formatting and Design
            1. Copy Styles
            2. Reset Formatting
            3. Report Design
              1. Themes
              2. Report Title
              3. Background Color
              4. Notes
                1. AutoML Explanations
              5. Discover Runtime Settings
              6. Tooltip
              7. Auto-Colorize
              8. Member Color Lock
            4. Visualization Design
              1. Quick Styles
              2. IBCS-Like Charts
                1. IBCS-Like Area Chart
                2. IBCS-Like Column Chart
                3. IBCS-Like Line Chart
                4. IBCS-Like Lollipop Chart
                5. IBCS-Like Waterfall Chart
              3. Formatting Panel
                1. Grid Formatting
                  1. Matrix Grid
                    1. Alignment
                    2. Alternate Rows
                    3. Column Size
                    4. Expand Icons
                    5. Grid Borders
                    6. Grid Font
                    7. Grid Font Alignment
                    8. Grid Padding
                    9. Row Area Size
                    10. Total Formatting
                  2. Data
                  3. Columns and Rows
                  4. Contextual Formatting
                  5. Clear Custom Formatting
                2. Cartesian Chart Formatting
                  1. Cartesian Charts
                  2. Chart Padding
                  3. Plot Area
                3. Segment Chart Formatting
                  1. Explode
                4. Radar Chart Formatting
                  1. Radar Line Chart
                5. Plotted Chart Formatting
                  1. Plotted Charts
                  2. Axis Position
                  3. Reference Line
                6. KPI Chart Formatting
                  1. Gauge Formatting
                    1. Gauge Labels
                      1. Gauge Value
                    2. Gauge Shape
                    3. Gauge Shadow
                    4. Auto Fit Labels
                    5. Gauge Scale
                  2. Bullet Chart Formatting
                    1. Bullet Chart Indicators
                    2. Bullet Chart Scale
                7. Advanced Chart Formatting
                  1. Circle Packing Chart
                  2. Sankey Chart
                  3. Sunburst Chart
                  4. Tree Map Chart
                  5. Waterfall Chart Formatting
                  6. Word Cloud Chart
                8. Map Formatting
                  1. Auto Center Map
                  2. Bubble Map Formatting
                  3. Shape Map Formatting
                  4. Geo Heat Map Formatting
                  5. Map Colors
                  6. Map Default Labels
                  7. Map Labels
                  8. Geospatial Defaults
                  9. Scale Control
                  10. Zoom Control
                9. Custom Visuals
              4. Common Design Capabilities
                1. Axes
                2. Color
                3. Data Labels
                  1. Data Label Optimization
                4. Legends
                  1. Combined Color Shape Legend
                  2. Legend Formatting
                  3. Series Editing
                5. Line Style
                6. Multi Chart Title
                7. Opacity
                8. Scale to Fit
                9. Shapes and Data Points
                10. Trellis Axes
                11. Visual Optimization
              5. Design Tools from the Ribbons
                1. Quick Styles
                  1. Grid Quick Styles
                  2. Cartesian Chart Quick Styles
                  3. Segment Chart Quick Styles
                  4. Plotted Chart Quick Styles
                  5. Map Quick Styles
                2. Axis Options
                3. Custom Reference Line
                4. Chart Border Width
                5. Mini Map
                6. Range Slider
                7. Custom Trellising
                8. Data Points
                9. Font Size
                10. Font Color
                11. Image Size
                12. Motion
                13. Readability
                14. Row Limit
                15. Show Data Grid
          5. Extended Functionality
            1. Discovery Actions
              1. Action Panel
                1. Jump To URL
                2. JavaScript Actions
                3. Tooltip Actions
                4. Action Library (PQL)
              2. Cube Actions
              3. Manage Actions
            2. Alerts Builder
              1. Advanced Alerts
            3. Workflows and Conversations in Discover
              1. Start a Conversation
              2. Managing Workflows and Conversations
            4. SAP Parameters for BW and HANA
            5. Data Catalog Viewer
          6. Manage Discoveries
            1. Save and Share Discoveries
            2. Printing in Discover
            3. Discovery Subscriptions
            4. Open and Edit Discoveries
            5. User Defaults (Discover)
        6. Auto Discover
          1. Auto Discover Explained
      3. Formulate
        1. Common Formulate Workspace
          1. Formulate Panels
          2. Model Metadata in Formulate
          3. Script Editor
          4. AI Generated Script
          5. Quick Discovery
          6. Quick Logic
          7. Functional Selection
          8. Internal Parameters
        2. Formulas (Members and Measures)
          1. Formula Ribbon
            1. Marketplace
            2. Multi-lingual Formulas
            3. Choose Language
          2. Formula Properties
            1. MDX Properties
            2. Formatting by Cell in MDX
            3. Dynamic Captions
              1. Walkthrough: Build Dynamic Captions
          3. Preview Panels
          4. Formula Script Editor
          5. Formula Examples
            1. Walkthrough: Percentage Markup Formula
            2. Walkthrough: Yearly Sales Variance
            3. Walkthrough: Custom Formula in Script Mode
        3. Lists (Sets)
          1. List Ribbon
            1. Move to Start or End
          2. List Properties
          3. List Script Editor
          4. List Actions
            1. Add
              1. Standard List
              2. Measure List
              3. Range List
              4. Full Month
              5. Full Quarter
              6. Full Week
              7. Full Year
              8. Month to Date
              9. Parallel Period
              10. Quarter To Date
              11. Week To Date
              12. Year To Date
            2. Derive
              1. Except/ Remove
              2. Intersect
              3. Set Intersect
              4. Union
            3. Filter
              1. Bottom Count
              2. Bottom Percent
              3. Bottom Sum
              4. Contains
              5. Ends With
              6. Equals
              7. Filter
              8. First
              9. Last
              10. Starts With
              11. Top Count
              12. Top Percent
              13. Top Sum
            4. Sort
              1. Natural Order
              2. Order by Label
              3. Order by Selection
              4. Order by Value
            5. Fork
              1. If
              2. Switch
          5. List Examples
            1. Build a List
            2. List in Script Mode
        4. KPIs
          1. KPI Ribbons
          2. Building a KPI
            1. KPI Dynamic Bands
            2. KPI Script Editor
          3. Using KPIs
            1. Gauge Color Types
            2. Gauge Indicator Types
          4. Walkthroughs: KPIs
        5. Custom Columns
          1. Custom Column Ribbon
          2. Custom Column Properties
            1. Custom Column Settings
            2. Custom Column Measures
            3. Creating Measures
          3. Custom Column Panels
            1. Preview Panel
            2. Model Attributes Panel
          4. Custom Column Examples
            1. Walkthrough: Create New Attribute
            2. Walkthrough: Create New Measure
            3. Walkthrough: Custom Column in Script Mode
        6. Parameters
          1. Parameter Designer
          2. Dynamic List Parameters
          3. Parameter Types
            1. Discrete Parameters
            2. Continuous Parameters
            3. Free Form Parameters
        7. Scripting
          1. Shared Scripting
        8. Custom Visualizations
          1. Custom Visual Ribbon
      4. Present
        1. Present Interface Differences
          1. Changing Present Interfaces
        2. Getting started with Present
          1. Building a Presentation using Chatbot
          2. Building 'Pro' Presentation
          3. Building 'Lite' Presentation
        3. Smart Present
        4. Present Lite
          1. Accessing a 'Lite' presentation
          2. Workspace
            1. Ribbon
            2. Toolbox
            3. Canvas
              1. Metadata panel
            4. Slides and sections
            5. Slicers
          3. Building 'Lite' presentations
            1. Building a new presentation
            2. Adding content to a presentation
              1. Adding existing visuals
              2. Creating visuals using Smart Reporting
              3. Creating visuals using Discover Lite
              4. Creating Slicers
              5. Adding Static or Variable Text
              6. Adding Shapes or Images
              7. Adding a Table of Contents
              8. Adding Miniature visuals
            3. Managing Interactions
            4. Formatting and Design
              1. Selecting Themes
              2. Using Layout tools
                1. Aligning and distributing items
                2. Grouping and ungrouping items
              3. Auto Layout
        5. Present Pro
          1. Accessing a 'Pro' presentation
          2. Workspace
            1. Ribbons
              1. Master Page Ribbon
            2. Toolbox
            3. Canvas
              1. Context Menus
              2. Metadata
              3. Canvas Size
            4. Slides and sections
            5. Slicers
            6. Content and Used Content
            7. Formatting Panel
            8. Targets
          3. Building a 'Pro' presentation
            1. Building a new 'Pro' presentation
              1. Tooltip Presentations
              2. Mobile Presentations
            2. Adding Content items
              1. Adding Visuals and Analytic data
                1. Adding existing visuals
                  1. Unlinking Content
                2. Creating visuals using Smart Reporting
                3. Creating visuals using Discover Lite
              2. Managing Slicers
                1. Adding an "advanced" slicer
                2. Adding a "quick" slicer
                3. Slicer Settings
                4. Slicer Styles
                5. Hidden Slicers
                6. Edit and Delete Slicers
                7. Duplicating Slicers
                8. Detaching Slicers
                9. Populating slicers with parameters
              3. Presentation Assets
                1. Static Shapes and Images
                  1. AI Image Generator
                2. Variable text fields
                  1. Adding a Table of Contents
                  2. Adding a "Model Processed Date"
                  3. Adding Slide Insights
                3. Dynamic web panels
                4. Integrating dynamic illustrations
                5. Dynamic text
                  1. Highlight dynamic text
                  2. Empty Strings in dynamic text
                  3. Auto Translate dynamic text
                6. Dynamic placeholders
                7. Dynamic Tooltips
            3. Interactivity
              1. Configuring Interactions
                1. Interaction Manager
                  1. Cross-Filtering Slicers Example
                  2. Cross-Highlighting Slicers Example
                2. Interaction Picker
                3. Auto Interact
                4. Showing Interactions
                5. Removing interactions
                6. Model Mapping
                7. Creating Targets
              2. Creating Actions
                1. Creating Slicer Actions
                2. Creating Visual Actions
                3. Creating Tooltip Actions
              3. Creating Dynamic Jump Actions
                1. Jump to Slide
                2. Jump to Content Item
                3. Jump to Tab
                4. Jump to URL
                5. Execute JavaScript
                6. Publication Print
            4. Formatting and Design
              1. Themes
              2. Master Pages
                1. Navigation Options
              3. Formatting and Format selection
                1. Grid Sizing
              4. Slicer Formatting
                1. Panel Settings
            5. Layouts
              1. Using layout containers
                1. Mini-Tab Layout
                  1. Conditional Display for Mini-Tabs
                2. Scroll Panel Layout
                3. Matrix Table Layout
              2. Using layout tools
                1. Adding Guides and Rulers
                2. Stacking order
                3. Aligning and distributing items
                4. Grouping and ungrouping items
              3. Visual Options
                1. Optimizing for Device Types
                2. Scaling assets
                  1. Auto Fit Labels
                  2. Auto Fit Graphic Text
                3. Panels
                4. Legends
                5. Range Sliders
                6. Miniature Visuals
              4. Auto Layout
            6. Runtime Settings
              1. Setting the scope of runtime interactions
              2. Configuring runtime capabilities
              3. Configuring model / hierarchy access
              4. Configuring the runtime timer
            7. Refresh snapshots in Present Pro
        6. Managing presentations
          1. Saving and sharing presentations
          2. Opening and editing presentations
          3. Running presentations
        7. Running Presentations
          1. Context Menus
            1. Zoom effects
            2. Triggering actions at runtime
          2. Present runtime menu
            1. Bookmarking slicer selections
            2. Pre-query slicers
          3. Interactivity at runtime
            1. Cross-Highlighting at Runtime
            2. Cross-Filtering at Runtime
            3. Sync Interactions at Runtime
            4. Multi-Select Highlighting
          4. Analyze Further
            1. OData Link
          5. Runtime Chatbot
            1. Using the Chatbot at Runtime
          6. Runtime automated insights
          7. Print in Present
          8. Subscriptions in Present
          9. Alerts
          10. Workflows and Conversations
          11. Panel tools at runtime
          12. Explanations at runtime
          13. Slide navigation at runtime
      5. Publish
        1. Publish
          1. Smart Publish
          2. Present Lite
            1. Present Lite
              1. Accessing a 'Lite' presentation
              2. Workspace
                1. Ribbon
                2. Toolbox
                3. Canvas
                  1. Metadata panel
                4. Slides and sections
                5. Slicers
              3. Building 'Lite' presentations
                1. Building a new presentation
                2. Adding content to a presentation
                  1. Adding existing visuals
                  2. Creating visuals using Smart Reporting
                  3. Creating visuals using Discover Lite
                  4. Creating Slicers
                  5. Adding Static or Variable Text
                  6. Adding Shapes or Images
                  7. Adding a Table of Contents
                  8. Adding Miniature visuals
                3. Managing Interactions
                4. Formatting and Design
                  1. Selecting Themes
                  2. Using Layout tools
                    1. Aligning and distributing items
                    2. Grouping and ungrouping items
                  3. Auto Layout
          3. Publish Pro
            1. Publication Overview
              1. Building Publications
                1. Publication Workspace
                2. Publish Ribbons
                3. Context Menus
                4. Text and Shapes
                5. Build a Publication
                6. Build a Publication using the Chatbot
            2. Publication Design
              1. AI Image Generator
              2. Refresh Snapshots
              3. Page Sizes and Orientation
              4. Content Layout Tools
              5. Publication Templates
              6. Auto Layout Publish
              7. Content Captioning
              8. Publication Legends
              9. Text Fields
              10. Flow Visual
              11. Grid Sizing
              12. Unlink Content
              13. Formatting Panel
                1. Panel Settings
              14. Show Warnings
              15. Layout Containers
                1. Matrix Table Layout
                2. Conditional Display
            3. Publication Analytics
              1. Publication Slicers and Interactions
                1. New Quick Slicer
                2. Advanced Slicer Wizard
                3. Page Repeater
                4. Interaction Manager
                5. Range Slicers in Publish
                6. Cross Model Mapping
              2. Add Dynamic Text to Publications
                1. Dynamic Text Editor
                2. Empty Strings
                3. Dynamic Place Holder
            4. Publishing and Distribution
              1. Printing in Publish
              2. Subscribe to Publication
              3. Scheduled Publishing
              4. PDF Bookmarks
              5. Link-Back
              6. Distribution
                1. Bulletin Board Distribution
                2. Email Distribution
                3. Static Distribution List
                4. Dynamic Distribution
                  1. Distribution via File Mapping
                    1. Walkthrough: File Mapping
                  2. Distribution via Data Mapping
                    1. Walkthrough: Data Mapping
                5. Triggers
              7. Access Scheduled Publications
      6. Illustrate
        1. Illustrate Ribbons
        2. Dynamic Images
          1. Dynamic Graphic Properties
          2. Import Images
          3. Build Dynamic Images
        3. Dynamic Text
          1. Dynamic Text Properties
          2. Build Dynamic Text
          3. Empty Strings
          4. Graphic Text
        4. Dynamic Tooltips
        5. Dynamic Functions
        6. Use Dynamic Images and Texts
      7. Tabulate
        1. Tabulate Pro
          1. Accessing Tabulate
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Workspace
            1. Tabulate Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Ribbons
            3. Tabulate Toolbox
            4. Tabulate Status Bar
            5. Tabulate Sheets
            6. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Gridlines
              2. Headers
              3. Themes
              4. Cell Formatting
              5. Number Formatting
              6. Tables
              7. Filtering and Sorting
              8. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Slicers
                1. Attaching Slicers
                2. Pre-Query Slicers (Tabulate)
              3. Parameters
                1. Attaching Parameters
                2. Editing Parameters
                3. Internal Parameters
              4. Managing Data Sources
                1. Cross Model Mapping
              5. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
          7. Solve Overview
            1. Optimization Explained
            2. Using Solve
            3. Solve Panel
              1. Solve Advanced Settings
            4. Complete Solve Example
        2. Tabulate Lite
          1. Accessing Tabulate Lite
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Lite Workspace
            1. Tabulate Lite Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Lite Ribbons
            3. Tabulate Lite Toolbox
            4. Slicers
            5. Tabulate Status Bar
            6. Tabulate Sheets
            7. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Themes
              2. Cell Formatting
              3. Number Formatting
              4. Tables
              5. Filtering and Sorting
              6. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
  3. Analyst User
    1. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
            1. Context Menu
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Quick Open
        3. App Tab Manager
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
          1. Dynamic Clipboard Tools
        3. Text Formatting
        4. Saving Content
          1. Assigning Content Access
        5. Print and Export
          1. Printing from Embedded Content
        6. Subscriptions
          1. Configure Subscriptions
        7. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
        8. Data Source Authentication
    2. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    3. Lite Apps
      1. Discover Lite
        1. Access Discover Lite
        2. Discover Lite Workspace
          1. Drop Zones
          2. Discover Lite Ribbon
            1. Axis Options
            2. Data Labels
            3. Data Points
            4. Grid Lines
          3. Model Metadata and Trees
        3. Build Visuals in Discover Lite
          1. Drop Zones
          2. Visualizations
            1. Quick Styles
          3. Dynamic Interactions
          4. Quick Calculations
          5. Context Calculations
        4. Manage Visuals in Discover Lite
        5. Conversations
      2. Present Lite
        1. Accessing a 'Lite' presentation
        2. Workspace
          1. Ribbon
          2. Toolbox
          3. Canvas
            1. Metadata panel
          4. Slides and sections
          5. Slicers
        3. Building 'Lite' presentations
          1. Building a new presentation
          2. Adding content to a presentation
            1. Adding existing visuals
            2. Creating visuals using Smart Reporting
            3. Creating visuals using Discover Lite
            4. Creating Slicers
            5. Adding Static or Variable Text
            6. Adding Shapes or Images
            7. Adding a Table of Contents
            8. Adding Miniature visuals
          3. Managing Interactions
          4. Formatting and Design
            1. Selecting Themes
            2. Using Layout tools
              1. Aligning and distributing items
              2. Grouping and ungrouping items
            3. Auto Layout
      3. Publish Lite
        1. Access Publish Lite
        2. Publish Lite Workspaces
          1. Publish Lite Ribbon
          2. Publish Lite Toolbox
          3. Publish Lite Pages
          4. Publish Lite Canvas
        3. Build Lite Publications
          1. Add Content
          2. Add Slicers
          3. Add Static Text
          4. Dynamic Text
            1. Dynamic Text Fields
            2. Dynamic Placeholders
          5. Table of Contents
          6. Add Static Graphics
          7. Context Menus
          8. Interaction Manager
          9. Themes
          10. Cover Pages
          11. Align and Distribute
          12. Grouping
        4. Manage Lite Publications
          1. Save Lite Publications
          2. Print and Export
          3. Subscriptions
          4. Link Back to Live Content
      4. Tabulate Lite
        1. Accessing Tabulate Lite
          1. Viewing Tabulate Content
          2. How to Enable/Disable Tabulate
        2. Tabulate Lite Workspace
          1. Tabulate Lite Canvas
            1. Zoom in or out of a sheet
          2. Tabulate Lite Ribbons
          3. Tabulate Lite Toolbox
          4. Slicers
          5. Tabulate Status Bar
          6. Tabulate Sheets
          7. Hiding and Showing Sheets
        3. Working with Spreadsheets
          1. Data Entry and Cells
            1. Rows and Columns
            2. Resizing Rows and Columns
            3. Hide and Show Rows and Columns
            4. Freeze Panes
            5. Clipboard
            6. Named Ranges
            7. Working with Formulas
              1. More Formula Details
              2. Formula Bar
              3. Formula Wizard
          2. Formatting
            1. Themes
            2. Cell Formatting
            3. Number Formatting
            4. Tables
            5. Filtering and Sorting
            6. Conditional Formats in Tabulate
              1. Applying Conditional Formats
          3. Using Live Data
            1. Importing Data and Content
              1. Smart Report
              2. Discover Lite
              3. Importing Existing Spreadsheets
            2. Blending Queries
        4. Creating Tabulate Visuals
          1. Drop Zones
          2. Formatting Panels
          3. Panel Layout
        5. Embedding in Present and Publish
        6. Managing Tabulations
          1. Saving Tabulations
          2. Printing and Exporting
          3. Mobile Access
  4. Viewer User
    1. Viewer Workflow Overview
    2. Viewer Home Page
      1. Viewer Home Menu
      2. Viewer System Info
      3. User Hub
    3. Content Management
      1. Content Types
      2. Content Manager
        1. Favorites
        2. Recents
        3. Content Explorer
        4. Most Used
        5. User Recommended
        6. Auto Recommended
        7. Content Search
      3. Schedules and Subscriptions
        1. Publications Board
        2. Alerts Board
        3. Subscriptions Board
        4. Workflow and Conversations Board
        5. Schedule Manager
          1. Alerts Manager
          2. Subscriptions Manager
    4. Interactive Content
      1. Data Discoveries
        1. Discovery Slicers
      2. Presentations
        1. Presentation Slicers
        2. Cross-Visual Interactions
        3. Panel Tools
      3. Viewer Interactions
        1. Conversations
        2. Alerts
        3. Analyze Further
          1. Members Search
    5. Manage Viewer Content
      1. Print and Export
      2. Subscribe to Content
        1. Link Back to Live Content
    6. Mobile and Tablet App
      1. Viewer Mobile Navigation
      2. Open Viewer Content
  5. Basic User
    1. Embed Experience
    2. Embed Hub
    3. Link Back to Live Content
    4. OData Link
  6. Mobile Client
    1. Mobile Phones
      1. Mobile Content Navigation
      2. Open Content
      3. Mobile Interactions
    2. Tablets
      1. App Menu
      2. Thumb Button and Context Menus
      3. Element Tree Navigation
      4. Accessing the Ribbons
      5. Accessing Sub-menus
      6. Quick Calculations
      7. Tablet Presentations
  7. Natural Language Interfaces
    1. Chatbot and Questions
      1. Access the Chatbot at Design Time
      2. Access the Chatbot at Runtime
      3. Chatbot Functions
        1. Speak to the Chatbot
      4. Writing Natural Language Queries
        1. NLQ: Asking a Basic Question
        2. NLQ: Advanced Intelligence
        3. NLQ: Visualizations
    2. Multiple LLM Engines
      1. Portable Language Model Guidance

Admin Help

  1. Admin Hub
    1. Diagnostic Dashboard
      1. Restarting Services
      2. Disabling Services
      3. In-Memory DB Status
    2. System Usage KPI
  2. Licensing
    1. License Change Wizard
    2. Deactivation of Pyramid
  3. Access
    1. Users
      1. Add Users
      2. Importing Users
      3. Domain Admin Rights
    2. Role Management
      1. Importing Roles
    3. Tenant Management
    4. Profiles
      1. Pro User Profile
      2. Analyst User Profile
      3. Viewer User Profile Settings
    5. User Defaults (Admin)
    6. Provisioning
  4. Security
    1. Authentication
      1. Multi-Factor Authentication
      2. Active Directory Setup
      3. Azure LDAPS Setup
      4. LDAP Setup
      5. SAML Authentication
        1. Azure SAML Setup
        2. ADFS SAML Setup
      6. OpenID Authentication
    2. Certificate Manager
      1. IMDB Encryption
    3. Server-Side Security
    4. Client Security
  5. Data
    1. Data Sources
      1. Data Source Setups
        1. Data Access with Windows Authentication
        2. Single Sign-on via OAuth
        3. Amazon OAuth Setup
        4. Box Setup
        5. Facebook Setup
        6. FTP Setup
        7. Google Security Setup
        8. Microsoft Analysis Services Setup
        9. Microsoft Fabric Security Setup
        10. ODBC Setup
        11. SAP BW Setup
        12. SAP HANA Setup
        13. SalesForce Setup
        14. X (Twitter) Setup
    2. Source Manager
      1. Data Source Servers (Admin)
      2. Database Management (Admin)
        1. Copy or Move a Data Model
      3. Data Model Management (Admin)
        1. Attribute Security
        2. Hierarchy Overlay
        3. Measure Security
        4. Measure Overlay
        5. Level Overlay
        6. Member Security
          1. Dynamic Member Security
          2. Security PQL Script Editor
    3. Pulse Nodes
    4. Kerberos Keytabs
    5. Custom Connectors
    6. Caching
    7. Query Limits
    8. Data Source Limits
    9. Global Settings
  6. Content
    1. Content Settings
    2. Migration Destinations
    3. Webhooks
    4. Custom Workflows
  7. Services
    1. General Settings
    2. Server Instances
      1. Service Memory Limits
    3. Runtime Services
    4. Task Services
    5. Solve Services
    6. Web Services
    7. File System
    8. Message Settings
  8. Schedules
    1. Task Manager
    2. Publication Schedules
    3. Alerts Schedules
    4. Subscriptions Schedules
    5. Models Schedules
    6. Auto Provisioning Jobs
    7. System Schedule
  9. Logs
    1. Entries
    2. Transaction Log
    3. Solve Logs
    4. System Log
    5. Deleted Items Log
    6. Log Settings
      1. Log Shipping
      2. Audit Trail Framework
  10. Mobile Devices
    1. Devices
    2. Mobile Devices Settings
  11. Design
    1. App Experience
    2. Themes
      1. Theme Editor
      2. Master Pages
    3. Custom Fonts
    4. Email Templates
      1. Add or Edit Email Template
    5. Hub Templates
      1. Build Hub Templates
      2. Hub Snippet Generator
  12. Geospatial
    1. Custom Maps
    2. Geospatial Settings
  13. AI and DSML
    1. AI Settings
    2. LLM Manager
      1. Integrating LLMs with Pyramid
    3. DSML Settings
    4. DSML Environments

Guides

  1. General Guides
    1. Pyramid Licensing
      1. Solve Access
    2. Application Languages
    3. Versions and Releases
      1. Version History
      2. Older Versions of Help
    4. Other Pyramid Help Resources
  2. Installation Guides
    1. Main Application
      1. System Requirements
      2. Quick Guide for Windows
      3. Quick Guide for Linux
      4. Upgrade Installations
      5. Unattended Installations
      6. Installation Steps
        1. Installation Rights
        2. Installation Directories
        3. Encryption and FIPS
          1. Encrypting Connections
        4. Server Deployment
          1. Adding and Removing Services
        5. Database Repository Installation
        6. Web Server Installation
          1. NGINX Web Server
          2. Create a Pyramid Website
        7. Initialization
        8. Post Installation Adjustments
        9. Offline Installation
          1. Offline Installation of R and Python
        10. Product Activation
          1. Trial Registrations
          2. New Deployment Activation
          3. Offline Registrations
          4. Changing Licensed Servers
      7. Repository Backups
        1. Recovery
    2. Kubernetes
      1. Recommendations for Kubernetes
      2. Kubernetes Configurator
      3. HELM Charts
        1. Unattended Kubernetes Configuration
        2. HELM Configuration
      4. Kubernetes Initialization
        1. Kubernetes Unattended Initialization
      5. Kubernetes Recipes
        1. Pyramid on AWS Kubernetes
        2. Pyramid on Azure Kubernetes
        3. Pyramid on GCP Kubernetes
    3. Pulse
      1. Pulse Installation Steps
    4. Cloud Server Quick Start
      1. Pyramid Analytics for AWS Marketplace
    5. Client Desktop
    6. System Maintenance Tools
    7. Uninstallation
  3. Configuration Guides
    1. Kerberos Delegation for Pyramid
    2. Amazon Load Balancer
  4. Deployment and Security Guides
    1. Scaling Pyramid
    2. Pyramid Usage
    3. User Deployment in Pyramid
    4. Application Security Overview
    5. Security Hardening Guide
    6. FIPS Compliance
    7. Mobile App Deployment
    8. Creating Accessible Content
  5. Miscellaneous Guides
    1. BI Office Content Conversion
    2. Generative AI Integration
    3. Dynamic Function Wizard
  6. SAP Guides
    1. SAP SSO 'SNC' Setup Guide
    2. Support for SAP BW Features
    3. Troubleshooting Guide for SAP BW

Tech Reference

  1. Query & Function Overview
    1. PQL & MDX Language Reference
      1. MDX Language
        1. Semantic Library (MDX)
          1. Date-Time Functions
            1. ClosingPeriod
            2. LastPeriods
            3. MTD
            4. OpeningPeriod
            5. ParallelPeriod
            6. PeriodsToDate
            7. QTD
            8. WTD
            9. YTD
          2. Hierarchical Functions
            1. Ascendants
            2. Children
            3. Cousin
            4. Descendants
            5. Dimension
            6. Dimensions
            7. DrilldownLevel
            8. DrilldownLevelBottom
            9. DrilldownLevelTop
            10. DrilldownMember
            11. DrilldownMemberBottom
            12. DrilldownMemberTop
            13. DrillupLevel
            14. DrillupMember
            15. FirstChild
            16. FirstSibling
            17. Hierarchy
            18. LastChild
            19. LastSibling
            20. Level
            21. Levels
            22. Ordinal
            23. Parent
            24. RollupChildren
            25. Root
            26. Siblings
          3. KPI Functions
            1. KPICurrentTimeMember
            2. KPIGoal
            3. KPIStatus
            4. KPITrend
            5. KPIValue
            6. KPIWeight
          4. List Functions
            1. AddCalculatedMembers
            2. AllMembers
            3. Ancestors
            4. Axis
            5. BottomCount
            6. BottomPercent
            7. BottomSum
            8. Crossjoin
            9. Distinct
            10. Except
            11. Exists
            12. Extract
            13. Filter
            14. Generate
            15. Head
            16. Hierarchize
            17. Intersect
            18. Leaves
            19. MeasureGroupMeasures
            20. Members
            21. NameToSet
            22. NonEmpty
            23. NonEmptyCrossjoin
            24. Order
            25. StripCalculatedMembers
            26. Subset
            27. Tail
            28. ToggleDrillState
            29. TopCount
            30. TopPercent
            31. TopSum
            32. Union
            33. Unorder
          5. Logical Functions
            1. Error
            2. IIf
            3. IsAncestor
            4. IsEmpty
            5. IsGeneration
            6. IsLeaf
            7. IsSibling
          6. Member Functions
            1. Ancestor
            2. Current
            3. CurrentMember
            4. DataMember
            5. DefaultMember
            6. Item
            7. Lag
            8. Lead
            9. LinkMember
            10. NextMember
            11. PrevMember
            12. UnknownMember
          7. Other Functions
            1. CalculationCurrentPass
            2. CalculationPassValue
            3. CoalesceEmpty
            4. CurrentOrdinal
            5. LookupCube
            6. Properties
            7. SetToArray
            8. UserName
            9. ValidMeasure
            10. Value
          8. Statistical Functions
            1. Aggregate
            2. Avg
            3. Correlation
            4. Count
            5. Covariance
            6. CovarianceN
            7. DistinctCount
            8. LinRegIntercept
            9. LinRegPoint
            10. LinRegR2
            11. LinRegSlope
            12. LinRegVariance
            13. Max
            14. Median
            15. Min
            16. Predict
            17. Rank
            18. Stdev
            19. StdevP
            20. Sum
            21. Variance
            22. VarianceP
            23. VisualTotals
          9. String Functions
            1. MemberToStr
            2. Name
            3. SetToStr
            4. StrToMember
            5. StrToSet
            6. StrToTuple
            7. StrToValue
            8. TupleToStr
            9. UniqueName
        2. VBA Library (MDX)
          1. Conversion Functions
            1. CBool
            2. CByte
            3. CCur
            4. CDate
            5. CDbl
            6. CDec
            7. CInt
            8. CLng
            9. CSng
            10. CStr
            11. CVar
            12. TypeName
          2. Date-Time Functions
            1. Date
            2. DateAdd
            3. DateDiff
            4. DatePart
            5. DateSerial
            6. DateValue
            7. Day
            8. Hour
            9. Minute
            10. Month
            11. Now
            12. Second
            13. Timer
            14. TimeSerial
            15. TimeValue
            16. Weekday
            17. Year
          3. Financial Functions
            1. DDB
            2. FV
            3. IPmt
            4. IRR
            5. MIRR
            6. NPer
            7. NPV
            8. Pmt
            9. PPmt
            10. PV
            11. Rate
            12. SLN
            13. SYD
          4. Logical Functions
            1. Choose
            2. Iif
            3. IsArray
            4. IsDate
            5. IsEmpty
            6. IsError
            7. IsMissing
            8. IsNull
            9. IsNumeric
            10. Switch
          5. Math Functions
            1. Abs
            2. Atn
            3. Cos
            4. Exp
            5. Fix
            6. Int
            7. Log
            8. QBColor
            9. RGB
            10. Rnd
            11. Round
            12. Sgn
            13. Sin
            14. Sqr
            15. Tan
          6. String Functions
            1. Asc
            2. Chr
            3. Format
            4. Hex
            5. InStr
            6. LCase
            7. Left
            8. Len
            9. LTrim
            10. Mid
            11. Oct
            12. Partition
            13. Right
            14. RTrim
            15. Space
            16. Str
            17. StrComp
            18. StrConv
            19. String
            20. Trim
            21. UCase
            22. Val
        3. Spreadsheet Library (PQL)
          1. Pyramid Functions
            1. DATA
            2. MEMBER
            3. PARAMETER
            4. SLICER
            5. SLICERCAPTION
          2. Database Functions
            1. DAVERAGE
            2. DCOUNT
            3. DCOUNTA
            4. DGET
            5. DMAX
            6. DMIN
            7. DPRODUCT
            8. DSTDEV
            9. DSTDEVP
            10. DSUM
            11. DVAR
            12. DVARP
          3. Date & Time Functions
            1. DATE
            2. DATEDIF
            3. DATEVALUE
            4. DAY
            5. DAYS
            6. DAYS360
            7. EDATE
            8. EOMONTH
            9. HOUR
            10. ISOWEEKNUM
            11. MINUTE
            12. MONTH
            13. NETWORKDAYS
            14. NETWORKDAYS.INTL
            15. NOW
            16. SECOND
            17. TIME
            18. TIMEVALUE
            19. TODAY
            20. WEEKDAY
            21. WEEKNUM
            22. WORKDAY
            23. WORKDAY.INTL
            24. YEAR
            25. YEARFRAC
          4. Engineering Functions
            1. BESSELI
            2. BESSELJ
            3. BESSELK
            4. BESSELY
            5. BIN2DEC
            6. BIN2HEX
            7. BIN2OCT
            8. BITAND
            9. BITLSHIFT
            10. BITOR
            11. BITRSHIFT
            12. BITXOR
            13. COMPLEX
            14. CONVERT
            15. DEC2BIN
            16. DEC2HEX
            17. DEC2OCT
            18. DELTA
            19. ERF
            20. ERF.PRECISE
            21. ERFC
            22. ERFC.PRECISE
            23. GESTEP
            24. HEX2BIN
            25. HEX2DEC
            26. HEX2OCT
            27. IMABS
            28. IMAGINARY
            29. IMARGUMENT
            30. IMCONJUGATE
            31. IMCOS
            32. IMCOSH
            33. IMCOT
            34. IMCSC
            35. IMCSCH
            36. IMDIV
            37. IMEXP
            38. IMLN
            39. IMLOG10
            40. IMLOG2
            41. IMPOWER
            42. IMPRODUCT
            43. IMREAL
            44. IMSEC
            45. IMSECH
            46. IMSIN
            47. IMSINH
            48. IMSQRT
            49. IMSUB
            50. IMSUM
            51. IMTAN
            52. OCT2BIN
            53. OCT2DEC
            54. OCT2HEX
          5. Financial Functions
            1. ACCRINT
            2. ACCRINTM
            3. AMORDEGRC
            4. AMORLINC
            5. COUPDAYBS
            6. COUPDAYS
            7. COUPDAYSNC
            8. COUPNCD
            9. COUPNUM
            10. COUPPCD
            11. CUMIPMT
            12. CUMPRINC
            13. DB
            14. DDB
            15. DISC
            16. DOLLARDE
            17. DOLLARFR
            18. DURATION
            19. EFFECT
            20. FV
            21. FVSCHEDULE
            22. INTRATE
            23. IPMT
            24. IRR
            25. ISPMT
            26. MDURATION
            27. MIRR
            28. NOMINAL
            29. NPER
            30. NPV
            31. ODDFPRICE
            32. ODDFYIELD
            33. ODDLPRICE
            34. ODDLYIELD
            35. EURO
            36. EUROCONVERT
            37. PDURATION
            38. PMT
            39. PPMT
            40. PRICE
            41. PRICEDISC
            42. PRICEMAT
            43. PV
            44. RATE
            45. RECEIVED
            46. RRI
            47. SLN
            48. SYD
            49. TBILLEQ
            50. TBILLPRICE
            51. TBILLYIELD
            52. VDB
            53. XIRR
            54. XNPV
            55. YIELD
            56. YIELDDISC
            57. YIELDMAT
          6. Information Functions
            1. ERROR.TYPE
            2. ISBLANK
            3. ISERR
            4. ISERROR
            5. ISEVEN
            6. ISFORMULA
            7. ISLOGICAL
            8. ISNA
            9. ISNONTEXT
            10. ISNUMBER
            11. ISODD
            12. ISOMITTED
            13. ISREF
            14. ISTEXT
            15. N
            16. NA
            17. SHEET
            18. SHEETS
            19. TYPE
          7. Logical Functions
            1. AND
            2. BYCOL
            3. BYROW
            4. IF
            5. IFERROR
            6. IFNA
            7. IFS
            8. LAMBDA
            9. LET
            10. MAKEARRAY
            11. MAP
            12. NOT
            13. OR
            14. REDUCE
            15. SCAN
            16. SWITCH
            17. XOR
          8. Lookup Functions
            1. ADDRESS
            2. AREAS
            3. CHOOSE
            4. CHOOSECOLS
            5. CHOOSEROWS
            6. COLUMN
            7. COLUMNS
            8. DROP
            9. EXPEND
            10. FILTER
            11. FORMULATEXT
            12. HLOOKUP
            13. HSTACK
            14. HYPERLINK
            15. INDEX
            16. INDIRECT
            17. LOOKUP
            18. MATCH
            19. OFFSET
            20. ROW
            21. ROWS
            22. SORT
            23. SORTBY
            24. TOCOL
            25. TOROW
            26. TRANSPOSE
            27. UNIQUE
            28. VLOOKUP
            29. VSTACK
            30. WRAPCOLS
            31. WRAPROWS
            32. XLOOKUP
            33. XMATCH
          9. Math & Trig Functions
            1. ABS
            2. ACOS
            3. ACOSH
            4. ACOT
            5. ACOTH
            6. AGGREGATE
            7. ARABIC
            8. ASIN
            9. ASINH
            10. ATAN
            11. ATAN2
            12. ATANH
            13. BASE
            14. CEILING
            15. CEILING.MATH
            16. CEILING.PRECISE
            17. COMBIN
            18. COMBINA
            19. COS
            20. COSH
            21. COT
            22. COTH
            23. CSC
            24. CSCH
            25. DECIMAL
            26. DEGREES
            27. EVEN
            28. EXP
            29. FACT
            30. FACTDOUBLE
            31. FLOOR.MATH
            32. FLOOR.PRECISE
            33. GCD
            34. INT
            35. ISO.CEILING
            36. LCM
            37. LN
            38. LOG
            39. LOG10
            40. MDETERM
            41. MINVERSE
            42. MMULT
            43. MOD
            44. MROUND
            45. MULTINOMIAL
            46. ODD
            47. PI
            48. POWER
            49. PRODUCT
            50. QUOTIENT
            51. RADIANS
            52. RAND
            53. RANDARRAY
            54. RANDBETWEEN
            55. ROMAN
            56. ROUND
            57. ROUNDDOWN
            58. ROUNDUP
            59. SEC
            60. SECH
            61. SEQUENCE
            62. SERIESSUM
            63. SIGN
            64. SIN
            65. SINH
            66. SQRT
            67. SQRTPI
            68. SUBTOTAL
            69. SUM
            70. SUMIF
            71. SUMIFS
            72. SUMPRODUCT
            73. SUMSQ
            74. SUMX2MY2
            75. SUMX2PY2
            76. SUMXMY2
            77. TAN
            78. TANH
            79. TRUNC
          10. Statistical Functions
            1. AVEDEV
            2. AVERAGE
            3. AVERAGEA
            4. AVERAGEIF
            5. AVERAGEIFS
            6. BETA.DIST
            7. BETA.INV
            8. BINOM.DIST
            9. BINOM.DIST.RANGE
            10. BINOM.INV
            11. CHISQ.DIST
            12. CHISQ.DIST.RT
            13. CHISQ.INV
            14. CHISQ.INV.RT
            15. CHISQ.TEST
            16. CONFIDENCE.NORM
            17. CONFIDENCE.T
            18. CORREL
            19. COUNT
            20. COUNTA
            21. COUNTBLANK
            22. COUNTIF
            23. COUNTIFS
            24. COVARIANCE.P
            25. COVARIANCE.S
            26. DEVSQ
            27. EXPON.DIST
            28. F.DIST
            29. F.DIST.RT
            30. F.INV
            31. F.INV.RT
            32. F.TEST
            33. FINV
            34. FISHER
            35. FISHERINV
            36. FORECAST
            37. FREQUENCY
            38. GAMMA
            39. GAMMA.DIST
            40. GAMMA.INV
            41. GAMMALN
            42. GAMMALN.PRECISE
            43. GAUSS
            44. GEOMEAN
            45. GROWTH
            46. HARMEAN
            47. HYPGEOM.DIST
            48. INTERCEPT
            49. KURT
            50. LARGE
            51. LINEST
            52. LOGEST
            53. LOGNORM.DIST
            54. LOGNORM.INV
            55. MAX
            56. MAXA
            57. MAXIFS
            58. MEDIAN
            59. MIN
            60. MINA
            61. MINIFS
            62. MODE.MULT
            63. MODE.SNGL
            64. NEGBINOM.DIST
            65. NORM.DIST
            66. NORM.INV
            67. NORM.S.DIST
            68. NORM.S.INV
            69. PEARSON
            70. PERCENTILE.EXC
            71. PERCENTILE.INC
            72. PERCENTRANK.EXC
            73. PERCENTRANK.INC
            74. PERMUT
            75. PERMUTATIONA
            76. PHI
            77. POISSON.DIST
            78. PROB
            79. QUARTILE.EXC
            80. QUARTILE.INC
            81. RANK.AVG
            82. RANK.EQ
            83. RSQ
            84. SKEW
            85. SKEW.P
            86. SLOPE
            87. SMALL
            88. STANDARDIZE
            89. STDEV.P
            90. STDEV.S
            91. STDEVA
            92. STDEVPA
            93. STEYX
            94. T.DIST
            95. T.DIST.2T
            96. T.DIST.RT
            97. T.INV
            98. T.INV.2T
            99. T.TEST
            100. TREND
            101. TRIMMEAN
            102. VAR.P
            103. VAR.S
            104. VARA
            105. VARPA
            106. WEIBULL.DIST
            107. Z.TEST
          11. Text Functions
            1. ASC
            2. BAHTTEXT
            3. CHAR
            4. CLEAN
            5. CODE
            6. CONCAT
            7. CONCATENATE
            8. DBCS
            9. DOLLAR
            10. EXACT
            11. FIND
            12. FIXED
            13. LEFT
            14. LEN
            15. LOWER
            16. MID
            17. OBJECT
            18. PROPER
            19. REPLACE
            20. REPT
            21. RIGHT
            22. SEARCH
            23. SEARCHB
            24. SUBSTITUTE
            25. T
            26. TEXT
            27. TEXTAFTER
            28. TEXTBEFORE
            29. TEXTJOIN
            30. TEXTSPLIT
            31. TRIM
            32. UNICHAR
            33. UNICODE
            34. UPPER
            35. VALUE
          12. Web Functions
            1. ENCODEURL
            2. FILTERJSON
            3. WEBSERVICE
          13. Compatibility Functions
            1. BETADIST
            2. BETAINV
            3. BINOMDIST
            4. CHIDIST
            5. CHIINV
            6. CHITEST
            7. CONFIDENCE
            8. COVAR
            9. CRITBINOM
            10. EXPONDIST
            11. FDIST
            12. FLOOR
            13. FTEST
            14. GAMMADIST
            15. GAMMAINV
            16. HYPGEOMDIST
            17. LOGINV
            18. LOGNORMDIST
            19. MODE
            20. NEGBINOMDIST
            21. NORMDIST
            22. NORMINV
            23. NORMSDIST
            24. NORMSINV
            25. PERCENTILE
            26. PERCENTRANK
            27. POISSON
            28. QUARTILE
            29. RANK
            30. STDEV
            31. STDEVP
            32. TDIST
            33. TINV
            34. TTEST
            35. VAR
            36. VARP
            37. WEIBULL
            38. ZTEST
    2. PQL Language
      1. Action Library (PQL)
        1. Cross-Model Functions
          1. DimensionCaption
          2. DimensionUniqueName
          3. HierarchyCaption
          4. HierarchyUniqueName
          5. MemberCaption
          6. MemberKey
          7. MemberUniqueName
          8. SourceMember
          9. TargetMember
        2. Jump Functions
          1. Captions
          2. CellValue
          3. ItemExists
          4. UniqueNames
      2. Common Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. CreateDate
          9. Date
          10. DateDiff
          11. DateFormat
          12. DateTime
          13. DateToTimeStamp
          14. DayNumber
          15. Hour
          16. Minute
          17. Month
          18. MonthNumber
          19. Quarter
          20. QuarterNumber
          21. Second
          22. StringToDate
          23. StringtoDateTime
          24. TimeStampToDate
          25. Week
          26. WeekNumber
          27. Year
        2. Formats Functions
          1. AutoFormat
          2. CurrencyDollars0
          3. CurrencyDollars2
          4. CurrencyEuros0
          5. CurrencyEuros2
          6. CurrencyPounds0
          7. CurrencyPounds2
          8. CurrencyRands0
          9. CurrencyRands2
          10. CurrencyShekels0
          11. CurrencyShekels2
          12. CurrencySwissFrancs0
          13. CurrencySwissFrancs2
          14. DateAmerican
          15. DateTimeAmerican
          16. DateTimeUniversal
          17. DateTimeWestern
          18. DateUniversal
          19. DateWestern
          20. Number0
          21. Number1
          22. Number2
          23. NumberBillions
          24. NumberMillions
          25. NumberThousands
          26. Percent0
          27. Percent1
          28. Percent2
        3. Geo Functions
          1. GeoDistance
        4. Identity Functions
          1. ApplicationCulture
          2. UserAdAccount
          3. UserAdDomain
          4. UserCustomData
          5. UserEmail
          6. UserFirstName
          7. UserLastName
          8. UserName
          9. UserPrincipalName
          10. UserPrincipalNameAlt
          11. UserProxyAccount
          12. UserProxyAccount2
          13. UserRoles
          14. UserRolesSet
          15. UserTenant
        5. Logical Functions
          1. Case
          2. Equals
          3. If
          4. IfNull
          5. IsNAN
          6. Loop
          7. LoopVector
          8. NotEquals
          9. Switch
        6. Math Functions
          1. Absolute
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Ceiling
          6. Coalesce
          7. ConvertToNumber
          8. Cos
          9. Ctan
          10. Divide
          11. E
          12. Exponent
          13. Floor
          14. Ln
          15. Log
          16. Log10
          17. Log2
          18. Multiply
          19. PI
          20. Power
          21. Random
          22. RandomDouble
          23. RemoveBlanks
          24. RGB
          25. Round
          26. Sin
          27. Tan
          28. ToDegrees
          29. ToRadians
        7. Statistical Functions
          1. Average
          2. Correlation
          3. Covariance
          4. DataSet
          5. IndexOfMax
          6. IndexOfMin
          7. Maximum
          8. Median
          9. Minimum
          10. PercentileRank
          11. Rank
          12. StandardDeviation
          13. Sum
        8. String Functions
          1. Contains
          2. EndsWith
          3. FindByPattern
          4. Format
          5. HasItem
          6. IndexOf
          7. Left
          8. Length
          9. LLM
          10. Replace
          11. Right
          12. StartsWith
          13. StringJoin
          14. SubString
          15. ToLower
          16. ToProper
          17. ToString
          18. ToUpper
          19. Trim
          20. TrimLeft
          21. TrimRight
          22. UrlDecode
          23. UrlEncode
      3. Dynamic Library (PQL)
        1. Column Functions
          1. DataSetColumn
          2. DataSetColumnRange
          3. FindColumnNumber
          4. LastColumn
          5. LookupMaxColumn
          6. LookupMinColumn
          7. NumberOfColumns
          8. TotalColumn
        2. Grid Functions
          1. CountAvg
          2. CountPercentile
          3. Data
          4. Forecast
          5. ForecastPercent
          6. ForecastValue
          7. FormattedData
          8. GridCountAvg
          9. GridCountPercentile
          10. IsCellEmpty
          11. IsCellValid
          12. IsEmptyQuery
          13. IsQueryValid
          14. Label
          15. LinearTrendSlopeValue
          16. MaxGrid
          17. MinGrid
          18. NumberOfCells
          19. Outlier
          20. TotalGrid
        3. Markup Functions
          1. Bold
          2. Bullet
          3. FontFormat
          4. HyperLink
          5. Image
          6. Italics
          7. LineBreak
          8. OrderedList
          9. Underline
          10. UnorderedList
        4. Row Functions
          1. DataSetRow
          2. DataSetRowRange
          3. FindRowNumber
          4. LastRow
          5. LookupMaxRow
          6. LookupMinRow
          7. NumberOfRows
          8. TotalRow
        5. Smart Functions
          1. SmartInsights
          2. SmartInsightsCategorical
      4. Granular Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. Age
          9. Date
          10. DateDiff
          11. DateFormat
          12. DayNumber
          13. DayOfWeekName
          14. DayOfWeekNumber
          15. Hour
          16. Minute
          17. Month
          18. MonthName
          19. MonthNumber
          20. Now
          21. Quarter
          22. QuarterNumber
          23. Second
          24. ToDate
          25. Today
          26. Week
          27. WeekNumber
          28. Year
        2. Identity Functions
          1. UserAdAccount
          2. UserAdDomain
          3. UserCustomData
          4. UserEmail
          5. UserFirstName
          6. UserLastName
          7. UserName
          8. UserPrincipalName
          9. UserPrincipalNameAlt
          10. UserProxyAccount
          11. UserProxyAccount2
          12. UserRoles
          13. UserTenant
        3. Logical Functions
          1. Case
          2. If
          3. IsNull
          4. Not
          5. NullIfEqual
          6. Switch
        4. Math Functions
          1. Abs
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Bin
          6. Ceiling
          7. Coalesce
          8. Cos
          9. Ctan
          10. E
          11. Exp
          12. Floor
          13. Log
          14. Log10
          15. Mod
          16. PI
          17. Power
          18. Random
          19. Round
          20. Sin
          21. Sqrt
          22. Tan
          23. ToDecimal
          24. ToDegrees
          25. ToInteger
          26. ToRadians
        5. String Functions
          1. Concat
          2. Contains
          3. EndsWith
          4. IndexOf
          5. Left
          6. Length
          7. Replace
          8. Right
          9. StartsWith
          10. SubString
          11. ToLower
          12. ToString
          13. ToUpper
          14. WordCount
      5. Semantic Library (PQL)
        1. Aggregate Functions
          1. Average
          2. Count
          3. CumulativeTimeSum
          4. DistinctCount
          5. FirstChild
          6. FirstQuartile
          7. LastChild
          8. Maximum
          9. Median
          10. Minimum
          11. Sum
          12. Text
          13. ThirdQuartile
        2. Date-Time Functions
          1. AddDays
          2. AddMonths
          3. AddQuarters
          4. AddWeeks
          5. AddYears
          6. ClosingPeriod
          7. CreateDate
          8. CurrentPeriod
          9. FullMonth
          10. FullQuarter
          11. FullWeek
          12. Fullyear
          13. MTD
          14. OpeningPeriod
          15. ParallelPeriod
          16. ParallelPeriods
          17. QTD
          18. WTD
          19. YTD
        3. Hierarchical Functions
          1. AllDescendants
          2. Ancestor
          3. Ascendants
          4. Children
          5. Cousin
          6. Descendants
          7. FirstChild
          8. FirstSibling
          9. GrandParent
          10. IsAncestor
          11. IsLeaf
          12. IsSibling
          13. LastChild
          14. LastSibling
          15. LeafDescendants
          16. Level
          17. Levels
          18. Ordinal
          19. Parent
          20. Siblings
        4. List Functions
          1. AllMembers
          2. BottomCount
          3. BottomPercent
          4. BottomSum
          5. Except
          6. Filter
          7. Head
          8. Intersect
          9. Leaves
          10. NonEmpty
          11. Not
          12. Order
          13. Range
          14. Subset
          15. Tail
          16. TopCount
          17. TopPercent
          18. TopSum
          19. Union
        5. Logical Functions
          1. HasChildren
          2. HasDataPoint
          3. HasDataPoints
          4. If
          5. ListContainsAll
          6. ListContainsAny
          7. Switch
        6. Member Functions
          1. ClosingElement
          2. CurrentMember
          3. DefaultMember
          4. FirstElement
          5. GetElement
          6. Lag
          7. LastElement
          8. Lead
          9. NextMember
          10. Offset
          11. OpeningElement
          12. PrevMember
        7. Statistical Functions
          1. Aggregate
          2. Average
          3. Correlation
          4. Count
          5. Covariance
          6. CovarianceP
          7. ExpRegA
          8. ExpRegB
          9. ExpRegPoint
          10. ExpRegR2
          11. LinRegIntercept
          12. LinRegPoint
          13. LinRegR2
          14. LinRegSlope
          15. LogRegA
          16. LogRegB
          17. LogRegPoint
          18. LogRegR2
          19. Maximum
          20. Median
          21. Minimum
          22. Multiply
          23. Percentile
          24. PowerRegA
          25. PowerRegB
          26. PowerRegPoint
          27. PowerRegR2
          28. Rank
          29. Sample
          30. SamplePercent
          31. Stdev
          32. StdevP
          33. Sum
          34. Variance
          35. VarianceP
        8. String Functions
          1. Caption
          2. Contains
          3. EndsWith
          4. Equals
          5. ModelCulture
          6. StartsWith
          7. StrToDate
          8. StrToMember
          9. StrToSet
          10. UniqueName
      6. Spreadsheet Library (PQL)
        1. Pyramid Functions
          1. DATA
          2. MEMBER
          3. PARAMETER
          4. SLICER
          5. SLICERCAPTION
        2. Database Functions
          1. DAVERAGE
          2. DCOUNT
          3. DCOUNTA
          4. DGET
          5. DMAX
          6. DMIN
          7. DPRODUCT
          8. DSTDEV
          9. DSTDEVP
          10. DSUM
          11. DVAR
          12. DVARP
        3. Date & Time Functions
          1. DATE
          2. DATEDIF
          3. DATEVALUE
          4. DAY
          5. DAYS
          6. DAYS360
          7. EDATE
          8. EOMONTH
          9. HOUR
          10. ISOWEEKNUM
          11. MINUTE
          12. MONTH
          13. NETWORKDAYS
          14. NETWORKDAYS.INTL
          15. NOW
          16. SECOND
          17. TIME
          18. TIMEVALUE
          19. TODAY
          20. WEEKDAY
          21. WEEKNUM
          22. WORKDAY
          23. WORKDAY.INTL
          24. YEAR
          25. YEARFRAC
        4. Engineering Functions
          1. BESSELI
          2. BESSELJ
          3. BESSELK
          4. BESSELY
          5. BIN2DEC
          6. BIN2HEX
          7. BIN2OCT
          8. BITAND
          9. BITLSHIFT
          10. BITOR
          11. BITRSHIFT
          12. BITXOR
          13. COMPLEX
          14. CONVERT
          15. DEC2BIN
          16. DEC2HEX
          17. DEC2OCT
          18. DELTA
          19. ERF
          20. ERF.PRECISE
          21. ERFC
          22. ERFC.PRECISE
          23. GESTEP
          24. HEX2BIN
          25. HEX2DEC
          26. HEX2OCT
          27. IMABS
          28. IMAGINARY
          29. IMARGUMENT
          30. IMCONJUGATE
          31. IMCOS
          32. IMCOSH
          33. IMCOT
          34. IMCSC
          35. IMCSCH
          36. IMDIV
          37. IMEXP
          38. IMLN
          39. IMLOG10
          40. IMLOG2
          41. IMPOWER
          42. IMPRODUCT
          43. IMREAL
          44. IMSEC
          45. IMSECH
          46. IMSIN
          47. IMSINH
          48. IMSQRT
          49. IMSUB
          50. IMSUM
          51. IMTAN
          52. OCT2BIN
          53. OCT2DEC
          54. OCT2HEX
        5. Financial Functions
          1. ACCRINT
          2. ACCRINTM
          3. AMORDEGRC
          4. AMORLINC
          5. COUPDAYBS
          6. COUPDAYS
          7. COUPDAYSNC
          8. COUPNCD
          9. COUPNUM
          10. COUPPCD
          11. CUMIPMT
          12. CUMPRINC
          13. DB
          14. DDB
          15. DISC
          16. DOLLARDE
          17. DOLLARFR
          18. DURATION
          19. EFFECT
          20. FV
          21. FVSCHEDULE
          22. INTRATE
          23. IPMT
          24. IRR
          25. ISPMT
          26. MDURATION
          27. MIRR
          28. NOMINAL
          29. NPER
          30. NPV
          31. ODDFPRICE
          32. ODDFYIELD
          33. ODDLPRICE
          34. ODDLYIELD
          35. EURO
          36. EUROCONVERT
          37. PDURATION
          38. PMT
          39. PPMT
          40. PRICE
          41. PRICEDISC
          42. PRICEMAT
          43. PV
          44. RATE
          45. RECEIVED
          46. RRI
          47. SLN
          48. SYD
          49. TBILLEQ
          50. TBILLPRICE
          51. TBILLYIELD
          52. VDB
          53. XIRR
          54. XNPV
          55. YIELD
          56. YIELDDISC
          57. YIELDMAT
        6. Information Functions
          1. ERROR.TYPE
          2. ISBLANK
          3. ISERR
          4. ISERROR
          5. ISEVEN
          6. ISFORMULA
          7. ISLOGICAL
          8. ISNA
          9. ISNONTEXT
          10. ISNUMBER
          11. ISODD
          12. ISOMITTED
          13. ISREF
          14. ISTEXT
          15. N
          16. NA
          17. SHEET
          18. SHEETS
          19. TYPE
        7. Logical Functions
          1. AND
          2. BYCOL
          3. BYROW
          4. IF
          5. IFERROR
          6. IFNA
          7. IFS
          8. LAMBDA
          9. LET
          10. MAKEARRAY
          11. MAP
          12. NOT
          13. OR
          14. REDUCE
          15. SCAN
          16. SWITCH
          17. XOR
        8. Lookup Functions
          1. ADDRESS
          2. AREAS
          3. CHOOSE
          4. CHOOSECOLS
          5. CHOOSEROWS
          6. COLUMN
          7. COLUMNS
          8. DROP
          9. EXPEND
          10. FILTER
          11. FORMULATEXT
          12. HLOOKUP
          13. HSTACK
          14. HYPERLINK
          15. INDEX
          16. INDIRECT
          17. LOOKUP
          18. MATCH
          19. OFFSET
          20. ROW
          21. ROWS
          22. SORT
          23. SORTBY
          24. TOCOL
          25. TOROW
          26. TRANSPOSE
          27. UNIQUE
          28. VLOOKUP
          29. VSTACK
          30. WRAPCOLS
          31. WRAPROWS
          32. XLOOKUP
          33. XMATCH
        9. Math & Trig Functions
          1. ABS
          2. ACOS
          3. ACOSH
          4. ACOT
          5. ACOTH
          6. AGGREGATE
          7. ARABIC
          8. ASIN
          9. ASINH
          10. ATAN
          11. ATAN2
          12. ATANH
          13. BASE
          14. CEILING
          15. CEILING.MATH
          16. CEILING.PRECISE
          17. COMBIN
          18. COMBINA
          19. COS
          20. COSH
          21. COT
          22. COTH
          23. CSC
          24. CSCH
          25. DECIMAL
          26. DEGREES
          27. EVEN
          28. EXP
          29. FACT
          30. FACTDOUBLE
          31. FLOOR.MATH
          32. FLOOR.PRECISE
          33. GCD
          34. INT
          35. ISO.CEILING
          36. LCM
          37. LN
          38. LOG
          39. LOG10
          40. MDETERM
          41. MINVERSE
          42. MMULT
          43. MOD
          44. MROUND
          45. MULTINOMIAL
          46. ODD
          47. PI
          48. POWER
          49. PRODUCT
          50. QUOTIENT
          51. RADIANS
          52. RAND
          53. RANDARRAY
          54. RANDBETWEEN
          55. ROMAN
          56. ROUND
          57. ROUNDDOWN
          58. ROUNDUP
          59. SEC
          60. SECH
          61. SEQUENCE
          62. SERIESSUM
          63. SIGN
          64. SIN
          65. SINH
          66. SQRT
          67. SQRTPI
          68. SUBTOTAL
          69. SUM
          70. SUMIF
          71. SUMIFS
          72. SUMPRODUCT
          73. SUMSQ
          74. SUMX2MY2
          75. SUMX2PY2
          76. SUMXMY2
          77. TAN
          78. TANH
          79. TRUNC
        10. Statistical Functions
          1. AVEDEV
          2. AVERAGE
          3. AVERAGEA
          4. AVERAGEIF
          5. AVERAGEIFS
          6. BETA.DIST
          7. BETA.INV
          8. BINOM.DIST
          9. BINOM.DIST.RANGE
          10. BINOM.INV
          11. CHISQ.DIST
          12. CHISQ.DIST.RT
          13. CHISQ.INV
          14. CHISQ.INV.RT
          15. CHISQ.TEST
          16. CONFIDENCE.NORM
          17. CONFIDENCE.T
          18. CORREL
          19. COUNT
          20. COUNTA
          21. COUNTBLANK
          22. COUNTIF
          23. COUNTIFS
          24. COVARIANCE.P
          25. COVARIANCE.S
          26. DEVSQ
          27. EXPON.DIST
          28. F.DIST
          29. F.DIST.RT
          30. F.INV
          31. F.INV.RT
          32. F.TEST
          33. FINV
          34. FISHER
          35. FISHERINV
          36. FORECAST
          37. FREQUENCY
          38. GAMMA
          39. GAMMA.DIST
          40. GAMMA.INV
          41. GAMMALN
          42. GAMMALN.PRECISE
          43. GAUSS
          44. GEOMEAN
          45. GROWTH
          46. HARMEAN
          47. HYPGEOM.DIST
          48. INTERCEPT
          49. KURT
          50. LARGE
          51. LINEST
          52. LOGEST
          53. LOGNORM.DIST
          54. LOGNORM.INV
          55. MAX
          56. MAXA
          57. MAXIFS
          58. MEDIAN
          59. MIN
          60. MINA
          61. MINIFS
          62. MODE.MULT
          63. MODE.SNGL
          64. NEGBINOM.DIST
          65. NORM.DIST
          66. NORM.INV
          67. NORM.S.DIST
          68. NORM.S.INV
          69. PEARSON
          70. PERCENTILE.EXC
          71. PERCENTILE.INC
          72. PERCENTRANK.EXC
          73. PERCENTRANK.INC
          74. PERMUT
          75. PERMUTATIONA
          76. PHI
          77. POISSON.DIST
          78. PROB
          79. QUARTILE.EXC
          80. QUARTILE.INC
          81. RANK.AVG
          82. RANK.EQ
          83. RSQ
          84. SKEW
          85. SKEW.P
          86. SLOPE
          87. SMALL
          88. STANDARDIZE
          89. STDEV.P
          90. STDEV.S
          91. STDEVA
          92. STDEVPA
          93. STEYX
          94. T.DIST
          95. T.DIST.2T
          96. T.DIST.RT
          97. T.INV
          98. T.INV.2T
          99. T.TEST
          100. TREND
          101. TRIMMEAN
          102. VAR.P
          103. VAR.S
          104. VARA
          105. VARPA
          106. WEIBULL.DIST
          107. Z.TEST
        11. Text Functions
          1. ASC
          2. BAHTTEXT
          3. CHAR
          4. CLEAN
          5. CODE
          6. CONCAT
          7. CONCATENATE
          8. DBCS
          9. DOLLAR
          10. EXACT
          11. FIND
          12. FIXED
          13. LEFT
          14. LEN
          15. LOWER
          16. MID
          17. OBJECT
          18. PROPER
          19. REPLACE
          20. REPT
          21. RIGHT
          22. SEARCH
          23. SEARCHB
          24. SUBSTITUTE
          25. T
          26. TEXT
          27. TEXTAFTER
          28. TEXTBEFORE
          29. TEXTJOIN
          30. TEXTSPLIT
          31. TRIM
          32. UNICHAR
          33. UNICODE
          34. UPPER
          35. VALUE
        12. Web Functions
          1. ENCODEURL
          2. FILTERJSON
          3. WEBSERVICE
        13. Compatibility Functions
          1. BETADIST
          2. BETAINV
          3. BINOMDIST
          4. CHIDIST
          5. CHIINV
          6. CHITEST
          7. CONFIDENCE
          8. COVAR
          9. CRITBINOM
          10. EXPONDIST
          11. FDIST
          12. FLOOR
          13. FTEST
          14. GAMMADIST
          15. GAMMAINV
          16. HYPGEOMDIST
          17. LOGINV
          18. LOGNORMDIST
          19. MODE
          20. NEGBINOMDIST
          21. NORMDIST
          22. NORMINV
          23. NORMSDIST
          24. NORMSINV
          25. PERCENTILE
          26. PERCENTRANK
          27. POISSON
          28. QUARTILE
          29. RANK
          30. STDEV
          31. STDEVP
          32. TDIST
          33. TINV
          34. TTEST
          35. VAR
          36. VARP
          37. WEIBULL
          38. ZTEST
      7. Context Library (PQL)
    3. Function Elements and Syntax
      1. Function Arguments
      2. Function Return Values
      3. Operators
        1. Arithmetic Operators
        2. Comparison Operators
        3. Logical Operators
      4. Data Object Syntax
        1. Dimensions and Tables
        2. Hierarchies and Columns
        3. Members and Elements
        4. Values and Measures
        5. Data Points or Tuples
        6. Lists and Sets
        7. SelfCalc
    4. Script Editors
      1. PQL Editor
  2. Extensibility
    1. Embedding
      1. Embed Flows
      2. Embed Authentication
      3. Embed Code Examples
      4. Embed Troubleshooting
      5. Embed API
        1. Embed API Objects
        2. PyramidEmbedClient
          1. Login
          2. LoginWindowsAuth
          3. LoginSamlAuth
          4. LoginOpenIdAuth
          5. Authentication Failure Callback
          6. Init
          7. Embed
          8. Hub
          9. QuickEmbed
          10. SetAuthToken
          11. GetAuthToken
          12. Host
          13. IsClientLoaded
          14. IsLoggedIn
          15. Content Embedding
            1. EmbedOptions
              1. QuickEmbedOptions
              2. Export Types
            2. Filter
              1. Add (filters)
              2. AddUniqueName (filters)
            3. Target
              1. Add (targets)
            4. EmbeddedResult
              1. GoToSlide
              2. EmbeddedType
              3. Query
              4. Hierarchy
              5. Member
          16. Hub Embedding
            1. Hub (Object)
              1. HubEmbedOptions
                1. Style
      6. Raw API (Embed API v1.0)
        1. Using Raw API
        2. Raw Code Embedding
    2. Direct Load (via URL)
      1. URL Parameterization
    3. External Parameterization
      1. Target Parameterization for Presentations
    4. Direct Launch (via URL)
  3. APIs
    1. Main API and SDKs
      1. Using REST
      2. Using SDKs
      3. REST API HTTP Status Codes
      4. Authentication APIs Overview
      5. API 3.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addScientistProfile
          5. addUserToRole
          6. addUsersToRole
          7. addViewerProfile
          8. changeUserLicense
          9. createRole
          10. createRoles
          11. createTenant
          12. createTenants
          13. createUsers
          14. createUsersFromSearch
          15. deleteProfile
          16. deleteRole
          17. deleteTenants
          18. deleteUser
          19. findRoles
          20. getAllAnalystProfiles
          21. getAllProfessionalProfiles
          22. getAllRoles
          23. getAllScientistProfiles
          24. getAllTenants
          25. getAllViewerProfiles
          26. getDefaultTenant
          27. getLicenseCount
          28. getLicenseExpirationDate
          29. getLicenseValidationStatus
          30. getMe
          31. getProfileForUser
          32. getPublicRoles
          33. getPublicRolesByTenant
          34. getRoleById
          35. getRoleGroups
          36. getRolesByUser
          37. getRolesbyProfile
          38. getTenantByName
          39. getTenantUnusedLicenseCount
          40. getTenantUsersByUserType
          41. getUser
          42. getUserByExternalId
          43. getUserLastLogin
          44. getUserStatusById
          45. getUserStatusByName
          46. getUsersByCurrentTenant
          47. getUsersByName
          48. getUsersByRole
          49. getUsersByTenant
          50. searchExternalGroups
          51. searchExternalUsers
          52. searchGroupUsers
          53. searchUserGroups
          54. setUserAdministrationLevel
          55. toggleUserStatus
          56. updateDomainAdminPermissions
          57. updateRoleGroups
          58. updateRoleProfiles
          59. updateTenant
          60. updateTenantSeats
          61. updateUserRoles
          62. updateUsers
          63. updateUsersFromSearch
          64. updateUsersPhones
        2. Analytics APIs
          1. createDiscover
          2. extractNlpQueryResult
          3. extractQueryResult
          4. getFormula
          5. getList
          6. getParameterElements
          7. setFormula
          8. setList
        3. Authentication APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserSAML
          10. authenticateUserWindows
        4. Content APIs
          1. addItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteItems
          10. deleteTag
          11. exportContent
          12. exportHub
          13. findContentItem
          14. findHub
          15. findItemsByTag
          16. findItemsByTagName
          17. getAllItemTags
          18. getAllItemsCreatedByUser
          19. getAllTags
          20. getAllTagsData
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getFavoriteItems
          24. getFolderItems
          25. getItem
          26. getItemRoles
          27. getItemRolesID
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getRecentItems
          31. getRecommendedItems
          32. getTagData
          33. getTenantPublicOrGroupFolder
          34. getUserGroupFolders
          35. getUserGroupRootFolder
          36. getUserPrivateFolder
          37. getUserPrivateRootFolder
          38. getUserPublicFolders
          39. getUserPublicRootFolder
          40. importContent
          41. importHub
          42. moveItems
          43. purgeContentItems
          44. removeItemsFromFavorites
          45. removeRolesFromItem
          46. removeTagFromItem
          47. renameItem
          48. restoreDeletedItems
        5. Datasources APIs
          1. addHierarchyOverlay
          2. addHierarchySecurity
          3. addMeasureOverlay
          4. addMeasureSecurity
          5. addMembersSecurity
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlay
          18. deleteHierarchySecurity
          19. deleteMaterializedModel
          20. deleteMeasureOverlay
          21. deleteMeasureSecurity
          22. deleteMembersSecurity
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelConnection
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataServerDetails
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchyOverlay
          38. getHierarchySecurity
          39. getItemConnectionString
          40. getMasterFlowProgressLogs
          41. getMasterFlowProgressUpdate
          42. getMasterFlowVariables
          43. getMeasureOverlay
          44. getMeasureSecurity
          45. getMemberSecurity
          46. getModelStructure
          47. getPulseNodesForTenant
          48. getRolesByDataBase
          49. getRolesByModel
          50. getRolesByServer
          51. getSourceByNode
          52. getTargetByNode
          53. getUserDataCatalog
          54. importModel
          55. recognizeDataBase
          56. recognizeModel
          57. togglePauseDatasource
          58. updateDataCatalog
          59. updateDataFlowNodeSchemas
          60. updateModelName
          61. updateModelProcessDate
          62. updateSourceNodeConnection
          63. updateTargetNodeConnection
          64. updateVariableConnection
          65. updateVariableValue
          66. validateMasterFlow
        6. Notification APIs
          1. getNotificationIndicators
          2. getNotificationIndicatorsAdminView
        7. Tasks APIs
          1. deleteSchedule
          2. deleteSchedules
          3. findSchedule
          4. getExecutions
          5. getScheduleExecutionStatus
          6. getSchedulesForUser
          7. getTaskData
          8. getTaskOutputs
          9. getTaskOutputsForUser
          10. getTasks
          11. getTasksIds
          12. reRunTask
          13. resumeSchedule
          14. runOnDemandSchedules
          15. runSchedule
          16. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      6. API 2.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addProfile
          5. addScientistProfile
          6. addUserToRole
          7. addUsersToRole
          8. addViewerProfile
          9. changeLicenseForUser
          10. changeRoleAdGroupMembership
          11. createRole
          12. createRoles
          13. createTenant
          14. createTenants
          15. createUserAd
          16. createUserDb
          17. createUserOpenId
          18. createUserSaml
          19. createUsersAd
          20. createUsersDb
          21. createUsersOpenId
          22. createUsersSaml
          23. deleteProfile
          24. deleteRole
          25. deleteTenants
          26. deleteUser
          27. getAllNonPrivateRoles
          28. getAllNonPrivateRolesByTenant
          29. getAllNonPrivateRolesIDByTenant
          30. getAllProfiles
          31. getAllProfilesByClientLicenseType
          32. getAllProfilesByClientLicenseTypeByTenantId
          33. getAllProfilesByTenantId
          34. getAllRoles
          35. getAllRolesByProfileId
          36. getAllRolesByUser
          37. getAllTenants
          38. getAllUsersByCurrentTenant
          39. getAllUsersByTenant
          40. getAllUsersDataByTenantAndLicenceType
          41. getAvailableTenantLicenseCount
          42. getDefaultTenant
          43. getGroupsByRole
          44. getLicenseCount
          45. getLicenseCount2
          46. getLicenseExpirationDate
          47. getLicenseValidationStatus
          48. getMe
          49. getPrivateProfileIdForUser
          50. getRoleById
          51. getRolesByName
          52. getTenantByName
          53. getUser
          54. getUserByOpenIdPrincipalName
          55. getUserBySamlPrincipalName
          56. getUserLastLogin
          57. getUserStatusById
          58. getUserStatusByName
          59. getUsersByName
          60. getUsersByRole
          61. searchAdGroups
          62. searchAdGroupsForUser
          63. searchAdUsers
          64. searchAdUsersForGroups
          65. setUserAdministrationLevel
          66. toggleEnableUser
          67. updateDomainAdminPermissions
          68. updateRolesByProfileId
          69. updateTenant
          70. updateTenantSeats
          71. updateUserAd
          72. updateUserDb
          73. updateUserOpenId
          74. updateUserRoles
          75. updateUserSaml
          76. updateUsersAd
          77. updateUsersDb
          78. updateUsersOpenId
          79. updateUsersPhones
          80. updateUsersSaml
        2. Auth APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserOPENIDAlt
          10. authenticateUserSAML
          11. authenticateUserSAMLAlt
          12. authenticateUserWindows
        3. Content APIs
          1. addContentItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteTag
          10. exportContent
          11. exportContent2
          12. exportHub
          13. findContentItem
          14. findItemsByTagId
          15. findItemsByTagName
          16. getAllItemTags
          17. getAllItemsCreatedByUser
          18. getAllTags
          19. getAllTagsData
          20. getAllUserContentItems
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getContentItemSecurityRoles
          24. getContentItemSecurityRolesID
          25. getFavoriteItems
          26. getFolderItems
          27. getItem
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getPrivateRootFolder
          31. getPublicOrGroupFolderByTenantId
          32. getRecentItems
          33. getRecommendedItems
          34. getTag
          35. getUserGroupFolders
          36. getUserGroupRootFolder
          37. getUserPrivateFolder
          38. getUserPrivateRootFolder
          39. getUserPublicFolders
          40. getUserPublicRootFolder
          41. importContent
          42. importHub
          43. moveItems
          44. purgeContentItems
          45. removeContentItemsFromFavorites
          46. removeRolesFromItem
          47. removeTagFromItem
          48. renameItem
          49. restoreSoftDeletedContentItems
          50. softDeleteContentItems
        4. Datasources APIs
          1. addHierarchyOverlayToModel
          2. addHierarchySecurityToModel
          3. addMeasureOverlayToModel
          4. addMeasureSecurityToModel
          5. addMembersSecurityToModel
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlayFromModel
          18. deleteHierarchySecurityFromModel
          19. deleteMaterializedModel
          20. deleteMeasureOverlayFromModel
          21. deleteMeasureSecurityFromModel
          22. deleteMembersSecurityFromModel
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportMaterializedModelDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelByName
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataModelStructure
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchySecurity
          38. getItemConnectionString
          39. getMasterFlowProgressUpdate
          40. getMasterFlowVariables
          41. getMeasureSecurity
          42. getMemberSecurity
          43. getModelHierarchyOverlay
          44. getModelMeasureOverlay
          45. getPulseNodesForTenant
          46. getRolesByDataBase
          47. getRolesByModel
          48. getRolesByServer
          49. getServerDataById
          50. getSourceByNodeId
          51. getTargetByNodeId
          52. getUserDataCatalog
          53. importMaterializedModelDataCatalog
          54. importModel
          55. recognizeDataBase
          56. recognizeModel
          57. searchConnectionString
          58. updateDataFlowNodeSchemas
          59. updateModelName
          60. updateModelProcessDate
          61. updateSourceNodeConnection
          62. updateTargetNodeConnection
          63. updateVariableConnection
          64. updateVariableValue
          65. validateMasterFlow
        5. Notification APIs
          1. getNotificationIndicators
        6. Query APIs
          1. extractNlpQueryResult
          2. extractQueryResult
          3. getParameterElements
        7. Tasks APIs
          1. deleteSchedule
          2. findSchedule
          3. getExecutions
          4. getScheduleExecutionStatus
          5. getSchedulesForUser
          6. getTaskData
          7. getTaskOutputs
          8. getTaskOutputsForUser
          9. getTasks
          10. getTasksIds
          11. reRunTask
          12. resumeSchedule
          13. runOnDemandSchedules
          14. runSchedule
          15. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      7. API Objects and Enumerations
        1. API Object Definitions
          1. AddHierarchyOverlayApiObject
          2. AddMeasureOverlayApiObject
          3. AddUserRoleData
          4. AddUsersRoleData
          5. AdditionalServerProperties
          6. AdminMultiTenantData
          7. AdminTypeApiData
          8. AnalystProfileApiData
          9. AnalyticsPermissions
          10. ApiResultLicenseStatus
          11. ApiResultTaskStatus
          12. AttributeTranslation
          13. BaseUserOpenIdCredentials
          14. BaseUserSamlCredentials
          15. CartesianCategoriesDropZone
          16. CartesianCategoriesHierarchyChip
          17. CartesianColorChip
          18. CartesianColorDropZone
          19. CartesianColorHierarchyChip
          20. CartesianColorMeasureChip
          21. CartesianFilterChip
          22. CartesianFilterDropZone
          23. CartesianFilterHierarchyChip
          24. CartesianFilterValuesChip
          25. CartesianLabelsChip
          26. CartesianLabelsDropZone
          27. CartesianLabelsHierarchyChip
          28. CartesianLabelsMeasureChip
          29. CartesianMotionDropZone
          30. CartesianMotionHierarchyChip
          31. CartesianShapeChip
          32. CartesianShapeDropZone
          33. CartesianShapeHierarchyChip
          34. CartesianShapeMeasureChip
          35. CartesianSizeDropZone
          36. CartesianSizeMeasureChip
          37. CartesianTooltipChip
          38. CartesianTooltipDropZone
          39. CartesianTooltipHierarchyChip
          40. CartesianTooltipMeasureChip
          41. CartesianTrellisHorizontalChip
          42. CartesianTrellisHorizontalDropZone
          43. CartesianTrellisHorizontalHierarchyChip
          44. CartesianTrellisHorizontalValuesChip
          45. CartesianTrellisVerticalChip
          46. CartesianTrellisVerticalDropZone
          47. CartesianTrellisVerticalHierarchyChip
          48. CartesianTrellisVerticalValuesChip
          49. CartesianValuesDropZone
          50. CartesianValuesMeasureChip
          51. CartesianValuesVisualTypes
          52. CartesianVisual
          53. ChangeItemDescriptionData
          54. ChangeUserLicenseObject
          55. ConnStringDscApiObject
          56. ConnectedItemsSearchCriteria
          57. ConnectionSearchCriteria
          58. ConnectionStringData
          59. ConnectionStringProperties
          60. ContentSearchParamsObject
          61. CreateRoleData
          62. CreateUserAdObject
          63. CreateUserDbObject
          64. CreateUserFromSearchObject
          65. CreateUserObject
          66. CreateUserOpenIdObject
          67. CreateUserSamlObject
          68. CreatedThemeResult
          69. DataBaseRecognitionObject
          70. DataCatalogDimension
          71. DataCatalogHierarchy
          72. DataCatalogHierarchyLevel
          73. DataCatalogItem
          74. DataCatalogMeasure
          75. DataCatalogModelMetadata
          76. DataCatalogProperty
          77. DataCatalogUpdateData
          78. DataSourceTableResult
          79. DataSourceUsedTablesResult
          80. DeleteHierarchyOverlayApiObject
          81. DeleteMeasureOverlayApiObject
          82. DeleteTenantApiData
          83. DiscoverData
          84. DiscoverDataCatalog
          85. DomainAdminPermissionAPIObject
          86. DomainAdminPermissions
          87. DomainSecurityObject
          88. DscApiData
          89. ElementSelectionData
          90. EnumerationOutput
          91. ErrorMessage
          92. ExecuteMasterFlowObject
          93. ExecuteMasterFlowResult
          94. ExecuteScheduleApiData
          95. ExecutionSettings
          96. ExecutionViewData
          97. ExportContentApiData
          98. ExportData
          99. ExportOptions
          100. ExternalGroupIdentifier
          101. ExternalGroupModel
          102. ExternalParameters
          103. ExternalSearchObject
          104. ExternalUserIdentifier
          105. ExternalUserModel
          106. FailedItemId
          107. FilterParameter
          108. FolderTenantObject
          109. FormulaData
          110. FtpSettings
          111. GetFolderItemsObject
          112. GetItemParamsObject
          113. GetOverlaySecurityObject
          114. GridColorChip
          115. GridColorDropZone
          116. GridColorHierarchyChip
          117. GridColorMeasureChip
          118. GridColsChip
          119. GridColsDropZone
          120. GridColsHierarchyChip
          121. GridColsValuesChip
          122. GridFilterChip
          123. GridFilterDropZone
          124. GridFilterHierarchyChip
          125. GridFilterValuesChip
          126. GridIndicatorDropZone
          127. GridIndicatorMeasureChip
          128. GridRowsChip
          129. GridRowsDropZone
          130. GridRowsHierarchyChip
          131. GridRowsValuesChip
          132. GridSizeDropZone
          133. GridSizeMeasureChip
          134. GridTooltipChip
          135. GridTooltipDropZone
          136. GridTooltipHierarchyChip
          137. GridTooltipMeasureChip
          138. GridValuesDropZone
          139. GridValuesMeasureChip
          140. GridVisual
          141. HierarchyElementSelection
          142. HierarchyMeasureSecurity
          143. HierarchyMeasureSecurityApiObject
          144. HierarchyOverlayData
          145. HierarchyOverlayToDeleteData
          146. HubApiObject
          147. ImportApiResultObject
          148. ImportMaterializedModelObject
          149. ItemId
          150. ItemParentApiData
          151. ItemRolePair
          152. ItemRolesForRemoval
          153. ItemRolesToBeAdded
          154. ItemsForFavorites
          155. ItemsToCopy
          156. ItemsToMove
          157. LdapGroupDetails
          158. LdapGroupIdentifier
          159. LdapSearchObject
          160. LdapUserObject
          161. LdapUsersSearchObject
          162. LicenseCountObject
          163. ListData
          164. MSOlapProperties
          165. MapColorChip
          166. MapColorDropZone
          167. MapColorHierarchyChip
          168. MapColorMeasureChip
          169. MapDetailsDropZone
          170. MapDetailsHierarchyChip
          171. MapFilterDropZone
          172. MapFilterHierarchyChip
          173. MapLocationChip
          174. MapLocationDropZone
          175. MapLocationHierarchyChip
          176. MapLocationMeasureChip
          177. MapMotionDropZone
          178. MapMotionHierarchyChip
          179. MapSizeDropZone
          180. MapSizeMeasureChip
          181. MapTooltipChip
          182. MapTooltipDropZone
          183. MapTooltipHierarchyChip
          184. MapTooltipMeasureChip
          185. MapVisual
          186. MasterFlowExecutionPathElement
          187. MasterFlowFindDataSourceObject
          188. MasterFlowModelNameObject
          189. MasterFlowOtherObject
          190. MasterFlowProgressLogItem
          191. MasterFlowProgressLogRequest
          192. MasterFlowProgressResult
          193. MasterFlowSchemasObject
          194. MasterFlowSourceConnectionObject
          195. MasterFlowSourceObject
          196. MasterFlowTargetConnectionObject
          197. MasterFlowTargetObject
          198. MasterFlowUpdatedVariableResult
          199. MasterFlowValidationResult
          200. MasterFlowVariableConnectionObject
          201. MasterFlowVariableObject
          202. MasterFlowVariableValueObject
          203. MasterFlowVariablesResult
          204. MasterFlowVariablesValueObject
          205. MaterializedApiObject
          206. MaterializedItemObject
          207. MeasureGroup
          208. MeasureOverlayData
          209. MeasureOverlayToDeleteData
          210. MemberDataApi
          211. MembersSecurity
          212. MembersSecurityApiObject
          213. MetaDataTranslation
          214. ModelDataCatalog
          215. ModelDataFlowSourceInfo
          216. ModelProcessDateObject
          217. ModelProcessDateResult
          218. ModelRecognitionObject
          219. ModelScheduleOnDemandObject
          220. ModelScheduleOnDemandResult
          221. ModelSyncColumnsSettings
          222. ModelingAggregationMapping
          223. ModelingColumn
          224. ModelingConfigTranslation
          225. ModelingFolderTranslations
          226. ModelingHierarchy
          227. ModelingHierarchyLevel
          228. ModelingMeasure
          229. ModelingModel
          230. ModelingProperty
          231. ModelingRelationship
          232. ModelingRelationshipColumnPair
          233. ModelingServerInfo
          234. ModelingTable
          235. ModelingTranslation
          236. ModifiedItemsResult
          237. ModifiedUsersResult
          238. NewFolderApiData
          239. NlpQueryExportData
          240. NotificationIndicatorsRequest
          241. NotificationIndicatorsResult
          242. OauthDataSourceSettings
          243. OdbcDirectQueryOptions
          244. PieApiObject
          245. ProPermissions
          246. ProProfileApiData
          247. ProfileApiData
          248. ProfilePermissionHolder
          249. ProfileRolesData
          250. PulseClientData
          251. PyramidContentItem
          252. PyramidItemIdentifier
          253. PyramidUserObject
          254. PyramidViewUserObject
          255. QueryExportData
          256. QueryOptions
          257. QueryTotalSettings
          258. RelatedItemData
          259. RenameItemApiData
          260. RoleAdGroupsModifyObject
          261. RoleData
          262. RoleGroupModifyObject
          263. RoleMinimalData
          264. RoleToItemApiData
          265. RolesInItemRemovalObject
          266. ScatterColorChip
          267. ScatterColorDropZone
          268. ScatterColorHierarchyChip
          269. ScatterColorMeasureChip
          270. ScatterDetailsDropZone
          271. ScatterDetailsHierarchyChip
          272. ScatterFilterChip
          273. ScatterFilterDropZone
          274. ScatterFilterHierarchyChip
          275. ScatterFilterValuesChip
          276. ScatterLabelsChip
          277. ScatterLabelsDropZone
          278. ScatterLabelsHierarchyChip
          279. ScatterLabelsMeasureChip
          280. ScatterMotionDropZone
          281. ScatterMotionHierarchyChip
          282. ScatterShapeChip
          283. ScatterShapeDropZone
          284. ScatterShapeHierarchyChip
          285. ScatterShapeMeasureChip
          286. ScatterSizeDropZone
          287. ScatterSizeMeasureChip
          288. ScatterTooltipChip
          289. ScatterTooltipDropZone
          290. ScatterTooltipHierarchyChip
          291. ScatterTooltipMeasureChip
          292. ScatterTrellisHorizontalChip
          293. ScatterTrellisHorizontalDropZone
          294. ScatterTrellisHorizontalHierarchyChip
          295. ScatterTrellisHorizontalValuesChip
          296. ScatterTrellisVerticalChip
          297. ScatterTrellisVerticalDropZone
          298. ScatterTrellisVerticalHierarchyChip
          299. ScatterTrellisVerticalValuesChip
          300. ScatterVisual
          301. ScatterXValuesDropZone
          302. ScatterXValuesMeasureChip
          303. ScatterYValuesDropZone
          304. ScatterYValuesMeasureChip
          305. ScheduleSearchCriteria
          306. ScheduleViewObject
          307. ScientistPermissions
          308. ScientistProfileApiData
          309. SearchAdGroupUsersData
          310. SearchAdUserGroupsData
          311. SearchCriteria
          312. SegmentColorChip
          313. SegmentColorDropZone
          314. SegmentColorHierarchyChip
          315. SegmentColorMeasureChip
          316. SegmentDetailsDropZone
          317. SegmentDetailsHierarchyChip
          318. SegmentFilterChip
          319. SegmentFilterDropZone
          320. SegmentFilterHierarchyChip
          321. SegmentFilterValuesChip
          322. SegmentLabelsChip
          323. SegmentLabelsDropZone
          324. SegmentLabelsHierarchyChip
          325. SegmentLabelsMeasureChip
          326. SegmentMotionDropZone
          327. SegmentMotionHierarchyChip
          328. SegmentSizeDropZone
          329. SegmentSizeMeasureChip
          330. SegmentTooltipChip
          331. SegmentTooltipDropZone
          332. SegmentTooltipHierarchyChip
          333. SegmentTooltipMeasureChip
          334. SegmentTrellisHorizontalChip
          335. SegmentTrellisHorizontalDropZone
          336. SegmentTrellisHorizontalHierarchyChip
          337. SegmentTrellisHorizontalValuesChip
          338. SegmentTrellisVerticalChip
          339. SegmentTrellisVerticalDropZone
          340. SegmentTrellisVerticalHierarchyChip
          341. SegmentTrellisVerticalValuesChip
          342. SegmentValuesDropZone
          343. SegmentValuesMeasureChip
          344. SegmentVisual
          345. ServerData
          346. SimpleModifierResult
          347. TabularColorChip
          348. TabularColorDropZone
          349. TabularColorHierarchyChip
          350. TabularColorMeasureChip
          351. TabularColsChip
          352. TabularColsDropZone
          353. TabularColsHierarchyChip
          354. TabularColsMeasureChip
          355. TabularFilterDropZone
          356. TabularFilterHierarchyChip
          357. TabularSizeDropZone
          358. TabularSizeMeasureChip
          359. TabularTooltipChip
          360. TabularTooltipDropZone
          361. TabularTooltipHierarchyChip
          362. TabularTooltipMeasureChip
          363. TabularVisual
          364. TagData
          365. TagUsageApiData
          366. TargetParameter
          367. TaskSummary
          368. TaskUserApiData
          369. TaskViewData
          370. TenantLicenseTypeData
          371. TenantObject
          372. TenantSettings
          373. TenantUsersGetObject
          374. ThemeApiObject
          375. ThemeListObject
          376. ThemeToItemsApiObject
          377. TogglePauseDatasourceApiData
          378. ToggleUserApiData
          379. TotalsSettings
          380. UpdateTenantSeatsObject
          381. UpdateUserAdObject
          382. UpdateUserDbObject
          383. UpdateUserFromSearchObject
          384. UpdateUserObject
          385. UpdateUserOpenIdObject
          386. UpdateUserSamlObject
          387. UserCredentials
          388. UserOpenIdCredentials
          389. UserPhone
          390. UserRolesData
          391. UserSamlCredentials
          392. UserTokenCredentials
          393. ViewerPermissions
          394. ViewerProfileApiData
          395. Visuals
        2. API Enumeration Definitions
          1. AccessType
          2. AdminType
          3. AggregationType
          4. AnalystPermissionOptions
          5. ApiResponseFormat
          6. AxisTotalsType
          7. BulkWritingType
          8. BwDatabaseListType
          9. BwInfoAreaTreeViewType
          10. CartesianBarVisualType
          11. CartesianColumnVisualType
          12. CartesianLineVisualType
          13. CartesianStackedBarVisualType
          14. CartesianStackedColumnVisualType
          15. CartesianVisualType
          16. ClashDefaultOption
          17. ClientLicenseType
          18. ColorMathFunction
          19. ConditionConjunctionType
          20. ConnectionStringType
          21. ContentItemObject
          22. ContentType
          23. ContentTypeObject
          24. CsvDelimiter
          25. CubeAuthMethod
          26. CustomRootCAType
          27. DataFlowModelType
          28. DataType
          29. DomainAdminPermissionType
          30. ElementSelectionDataType
          31. EtlProcessStatus
          32. EtlSyncModelColumnsType
          33. ExternalSearchType
          34. FilterHierarchyType
          35. FilterValuesType
          36. FirstWorkday
          37. FtpDataMode
          38. FtpSecurityType
          39. GaType
          40. GridColorOption
          41. HideMemberType
          42. HierarchyCategory
          43. HierarchyOverlayProperty
          44. HierarchyType
          45. IsolationMode
          46. ItemType
          47. JoinType
          48. KpiAttributeType
          49. LanguageType
          50. LdapSearchType
          51. LicenseStatus
          52. MapVisualType
          53. MaskingMethodType
          54. MaterializedItemType
          55. MeasureFormat
          56. MeasureMapOptions
          57. MeasureOverlayProperty
          58. ModelAttributeType
          59. ModelingColumnCategories
          60. ModelingColumnType
          61. ModelingTableType
          62. MsOlapConnectionType
          63. OpenIdAuthType
          64. OpenIdResponseType
          65. OperatorType
          66. PaperType
          67. ParentChildOrphans
          68. ParentChildRollupType
          69. PermissionBitIndex
          70. PrintingOutputType
          71. ProPermissionOptions
          72. QueryCacheMode
          73. QueryTotalPosition
          74. RoleAssignment
          75. RoleAssignmentType
          76. RootFolderType
          77. SapBwServerConnectionType
          78. ScatterVisualType
          79. ScheduleDataType
          80. ScheduleStatus
          81. ScheduleType
          82. ScientistPermissionOptions
          83. SearchMatchType
          84. SearchRootFolderType
          85. SecurityType
          86. SegmentVisualType
          87. ServerAuthenticationMethod
          88. ServerEffectiveUserName
          89. ServiceStatus
          90. SizeDropZoneOptions
          91. SizeMathFunction
          92. SparkTransportMode
          93. SyntaxType
          94. TagType
          95. TaskStatus
          96. UpdateSchemaValidation
          97. UserProfileType
          98. UserStatus
          99. ValidRootFolderType
          100. ValuesDropZoneOptions
          101. VariableType
          102. ViewerPermissionOptions
    2. Custom Visual API
      1. Custom Visual APIs 2.0
        1. Getting Started with the CV API
          1. Custom Visual Example - Aster Plot
        2. CvApi2
          1. Canvas
            1. Style
          2. ResultSet
            1. Data
              1. TrellisData
                1. Datapoint
                  1. Numerics
                    1. Value
            2. Dropzone
              1. Chip
                1. Element
          3. VisualConfig
          4. Utils
          5. ExternalLibraries
            1. D3Libraries
            2. UtilsLibraries
          6. Enums
            1. ChipType
            2. ColorRangeType
            3. DropZoneType
            4. Event
    3. Custom WorkFlow API
      1. Using the WorkFlow API
        1. Custom Workflow API Example
      2. Workflow API Overview
      3. WorkflowApi
        1. Canvas
        2. WorkflowThread
          1. Entry
            1. Attachment
          2. Contact
        3. Session
        4. Utilities
        5. ExternalLibraries
        6. Enums
          1. AttachmentType
          2. ContactType
          3. ThemeType
          4. WorkflowThreadType

Video Tutorials

  1. Pro Videos
    1. Model Videos
    2. Discover Videos
      1. Discover Visualization Videos
      2. Discover Analytics Videos
    3. Present Videos
    4. Publish Videos
    5. Formulate Videos
    6. Tabulate Tutorial Videos
    7. Illustrate Videos
    8. Content Manager Videos
    9. Admin Videos
  2. Analyst Videos
  3. Viewer Videos

Pyramid Analytics © 2017-2024